Run-Time Error - Database ... is being prevented from being open

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I am getting a run-time error "The database has been placed in a state
by the user 'Admin' on machine .... that prevents it from being opened or
locked."

I also get another runtime error, "Could not use; file already in use.

I get these errors even if I close the VBA Editor and close the Form I am
working and reopen the Form and try to access the database via the Form.

The only way I know how to get around this problem is to close MS Access and
re-open it. Does anyone know what is going on?

Thanks,
 
"Eddie's Bakery and Cafe'"
Hi, I am getting a run-time error "The database has been placed in a state
by the user 'Admin' on machine .... that prevents it from being opened or
locked."

I also get another runtime error, "Could not use; file already in use.

I get these errors even if I close the VBA Editor and close the Form I am
working and reopen the Form and try to access the database via the Form.

The only way I know how to get around this problem is to close MS Access and
re-open it. Does anyone know what is going on?

Thanks,
Click to expand...


Eddie's Bakery and Cafe',

I seem to remember getting that error a lot while working with MS
Access 2000 SP-0. In SP-3 and 4 . . . I can't remember seeing it.

What O/S and SP, and what version of MS Access and SP, are you
running?

Sincerely,

Chris O.
 
Hi Chris,

Thanks for taking my question, I just purchased MS Access 2003 back in Nov.
I don't think I have loaded any SP yet (I am not sure how to do this -
sorry). I am running XP - the XP OS has all the latest SP's installed.

Thanks for you time,

Eddie
 
Thanks for taking my question, I just purchased MS Access 2003 back in Nov.
I don't think I have loaded any SP yet (I am not sure how to do this -
sorry). I am running XP - the XP OS has all the latest SP's installed.
Click to expand...

PMFJI - to get the Service Packs you can go to Microsoft's Office
Update website. The current address (they keep changing it <g>) is

http://v5.windowsupdate.microsoft.com/v5consumer/default.aspx?ln=en-us

John W. Vinson[MVP]
 
Thanks for the feedback. I can't update my system until Monday. I'm hopeful
this will fix the problem.
 
After updating my MS Acess 2003 to SP 2 Builds 2600, I am still getting the
runtime error - "The database has been placed in a state by the user 'Admin'
on machine .... that prevents it from being opened or locked."

Your help is greatly appreciated

Thanks, Eddie
 
After updating my MS Acess 2003 to SP 2 Builds 2600, I am still getting the
runtime error - "The database has been placed in a state by the user 'Admin'
on machine .... that prevents it from being opened or locked."
Click to expand...

Delete any .ldb file in the same directory as your database; you may
also want to check Tony Toews' corruption FAQ at

http://www.granite.ab.ca/access/corruptmdbs.htm

or elsewhere on his website.


John W. Vinson[MVP]
 
Back
Top