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

  • Thread starter Eddie's Bakery and Cafe'
  • Start date
E

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,
 
C

Chris2

"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.
 
E

Eddie's Bakery and Cafe'

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
 
J

John Vinson

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]
 
E

Eddie's Bakery and Cafe'

Thanks for the feedback. I can't update my system until Monday. I'm hopeful
this will fix the problem.
 
E

Eddie's Bakery and Cafe'

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
 
J

John Vinson

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]
 
Top