Unable to open db - 'File already in use'

[Dave_cha]

I have a centrally stored db which is accessed by numerous network users. Earlier today the server on which the db resides crashed. Following reboot, users have been unable to access the db and are given the following error msg;

"Couldn't use <db name>;file already in use"

I know that if I leave the server until tomorrow it will automatically kill all connections overnight which will resolve this issue. A controlled shutdown would have to wait until after normal working hours. In the meantime users can't access the db. Is there any other way of overcoming or preventing this problem?

The server is a Netware 5 server.

Thanks

 

[Autoeng]

You can try and delete the .ldb file which will clear the error but sometimes that won't work. See this post on the subject.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36068

Autoeng

 

[Dave_cha]

Thanks Autoeng. Following the server reboot however, there was no ldb file associated to this db.
There's also a help sheet on Technet which refers to this problem on Netware servers and suggests granting R, W, C & D rights to users to allow them to create the ldb file. Users already have these rights though???

 

[Autoeng]

Whenever you open a db (secured or not) an ldb file is created. If your db is split it will be in the same directory as the back end. If not it will be in the same directory as the db. It might be a hidden file so in Explorer go to View and select Hidden files. If you are not able to get in and get the error message you indicated the hanging ldb file is the problem.

Autoeng

 

[dungstar]

Thanks for that post Dave. That was the exact same problem we were experiencing. Here's the technet page you refered to.

http://support.microsoft.com/default.aspx?scid=kb;en-us;202171

This solution did work for us. You have to make sure that the [C]reate right is set for all users so they can create the ldb file.