Error Message

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi

I have Access 2002 and I have a big Access DB where I'm
using a lot of ADO et DAO when I tried to change the code
in VBA and after I return to test my code and my forms I
have always this message:

the database has been placed in a State by user 'Admin'
on machine 'Ermione' that prevents it from being opened
or locked

I checked all the opened Connection With the database and
I'm sure to close every connection after open it

Did somebody know the problem

Thanks

Chris
 
Are you using ADO to access tables w/in the same DB as the VBA code? And if
so are you trying to reference the DB using a connection string? Try using
"Set cnLocal = CurrentProject.AccessConnection" or
"CurrentProject.Connection" where cnLocal is ADODB.Connection.

That solved the problem for me.

Eric Dreksler
 
Back
Top