..system.mdw file in use, can't open

[Alison Towerton]

Our server just had to be re-booted and now it won't let
us open multiple instances of Access. How can we fix
this...?
thanks
Alison

 

[Scott McDaniel]

Check for the existence of a stray .lbd file in the same directory as your
data tables. The file will be <NameOfYourTables>.lbd. If you find it,
delete it (Access/Jet will rebuild it for you when you attempt to log back
in)

 

[Lynn Trapp]

Alison,
In addition to Scott's comment, I have seen times when the .mdw file you are
using will become corrupted. The server reboot -- especially if it was
sudden -- would be a good suspect for that. You should be able to compact
and repair the system.mdw file just like any other Access database.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp