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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eddie's Bakery and Cafe' - 25 Feb 2005 20:27 GMT

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,

Reply to this Message

Chris2 - 26 Feb 2005 00:25 GMT

> 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
[quoted text clipped - 9 lines]
>
> Thanks,

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.

Reply to this Message

Eddie's Bakery and Cafe' - 26 Feb 2005 22:33 GMT

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

> > Hi, I am getting a run-time error "The database has been placed in
> a state
[quoted text clipped - 27 lines]
>
> Chris O.

Reply to this Message

John Vinson - 27 Feb 2005 00:47 GMT

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

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]

Reply to this Message

Eddie's Bakery and Cafe' - 28 Feb 2005 23:57 GMT

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

> >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 -
[quoted text clipped - 6 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 01 Mar 2005 02:55 GMT

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

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]

Reply to this Message

Eddie's Bakery and Cafe' - 27 Feb 2005 02:07 GMT

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

> Hi Chris,
>
[quoted text clipped - 37 lines]
> >
> > Chris O.

Reply to this Message