I have 2 separate forms. When i try to update the database using the 2nd form, I get "The database has been placed in a state by user 'Admin' on machine 'MAYS' that prevents it from being opened or locked.

Each form has the following VBA code:

 Set wrkJet = CreateWorkspace("NewJetWorkspace", _
           "admin", "", dbUseJet)
    Set db = wrkJet.OpenDatabase("Youth Conference.mdb")

.
.(some insert and update statements are here)
.
.
 wrkJet.Close

Can someone please help!

Thanks!

when the first form opens the database, it is probably opening it exclusively. There should be another parameter that tells it to open it shared.




Sal

Thanks!

how to prevent the following error
The database has been placed in a state by user 'Admin' on machine 'Machine Name' that prevents it from being opened or locked.
in C#

what is the solution for the following error using C#
The database has been placed in a state by user 'Admin' on machine 'Machine Name' that prevents it from being opened or locked.