Recent content by francky

Thanks for your answer. It's exactly my problem. I will install the service pack 3 of office 2000. Francky

My database is corrupted. In the visual basic windows, a form appears but does not exist. When I open my database, I receive a message : "Erreur d'accès au fichier" (in french) How can I delete this form ? I tried to create a new database and import all the objects but without...

All is in the subject How can I do to disable the msgbox "Activate macros" ? How can I do to disable the msgbox regarding the links AND DISABLE THE LINKS !!! Thanks in advance Francky

Thanks Ken All is alright It was so obvious !!! Francky

I have a problem with Dim db as DAO.Database !!! The message (in french) is : "Type défini par l'utilisateur non défini" Type defined by the user not defined !!!???

I want to read the table A and write in the table B Table A Field1 Field2 AA 5 BB 3 CC 2 Resutl in the Table B Field1 AA AA AA AA AA BB BB BB CC CC But how to define the recordsets With access 97 Dim db as database Dim A as...

Thanks for your help I will try that asap

Can you give me more explanation

When 2 persons use the same form, the second can't confirm his operation Here is the code : Dim cn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim StrSql As String Set cn = CurrentProject.Connection cn.BeginTrans StrSql = "Select * FROM QryEtik WHERE etservice =" & Chr(34)...

OK It's running I upgraded the MDAC version to 2.6 SP2 and all is alright Thanks for all and particularly for cmmrfrds ? Franck

I downloaded the MDAC Component Checker and run it. The result is : "The MDAC version that is closest to the version on your computer is 2.5 SP1 (2.51.5303.5) Do I have to upgrade with MDAC 2.5 SP2 or higher ? Even with "NEW" before adodb.connection, I always receive the same...

Thanks for your help. Here is the code Private Sub CmdOpt5_Click() Dim cn As ADODB.Connection Dim rst As New ADODB.Recordset Dim StrSql As String [Set cn = CurrentProject.Connection] ??? cn.BeginTrans StrSql = "Select * From QryDroit where dropt= 5" rst.Open StrSql, cn, adOpenKeyset...

Hi Marty, ' Buffer size for the return string. Const lpnLength As Integer = 255 ' Get return buffer space. Dim Status As Integer ' For getting user information. Dim lpName, lpUserName As String ' Assign the buffer size constant to lpUserName. lpUserName = Space$(lpnLength + 1) ' Get the...

Thanks everybody for all But the problem is always the same even with the Nick's solution On the line "Set cn = CurrentProject.Connection" or ".ConnectionString = CurrentProject.Connection" from the exemple of Nick, I receive a message box: Erreur d'exécution '-2147220999...

I work with W2K, Access 2000 I don't know the MDAC version I don't understand your last question about the ADO library It seems there are a lot of differences between access 97 and access 2000 I just want to test if the current user gets the authorization to use an option I use a table with an...