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!
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!