Error Message

[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

 

[Eric Dreksler]

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

 

[Eric Dreksler]

To clarify my earlier answer a little better try page two of the following
article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;281998

That should help a little better,

Eric Dreksler