The database has been placed in a state by user 'Admin' on ...

mays0515

Registered User.
Local time
Yesterday, 19:39
Joined
May 4, 2004
Messages
15
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!
 

Users who are viewing this thread

Back
Top Bottom