error when trying to open db..

[terpster]

We have a database that sits on a shared directory on our server. As of last night we keep getting the following error message.

Could not use H:\projects\projects.mdb file already in use.

Noone is in the database. Please help!

Thanks from all of us here trying to use the db!

 

[jebry]

Hi!

Look for a projects.ldb file and, if you find one, delete it.

hth


Jeff Bridgham
bridgham@purdue.edu

 

[KenReay]

Hi

Has someone crashed out of the db leaving the lock file in place, look in same folder as mdb, for a file with extension .ldb, if you are SURE noone is in db, then delete the .LDB

If that does not do it, would it be too much disruption to restart the server ?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[terpster]

there is no lock file. That was the first thing I looked for, I should have mentioned that in my earlier post. I can see what I can do to have the admin restart the server. But I was hoping there was another way around that.