Deleting ldb file

[blackte]

Help - I have a database on a server many users that for some reason has an ldb file that I can not delete. I have viewed the file and it show my address on it. I have tried a couple of thing including altering a record on the database, and also rebooting my machine with no help. I have tried to rename and delete the file, it says it's in use. I did get an ldbviewer from Microsoft's website and it states no users are on the database. How can I delete this file? I need to update my application and currently can not. Any help with this would be greatly appreciated. Thanks again

Travis Thanks Travis.

 

[Klopper]

Contents of an .ldb can also be viwed by right clicking and opening the file with notepa or similar. Ensure this is empty before tring to delete file.

 

[Klopper]

Contents of an .ldb can also be viwed by right clicking and opening the file with notepa or similar. Ensure this is empty before trying to delete file.

 

[blackte]

Klopper, I have tried deleting the single row of data in the file and saving it, and then trying to delete, but no luck. Thanks Thanks Travis.

 

[jfischer]

Your server probably has a lock on the .LDB file so that you cannot delete it. Your network administrator should be able to release the lock for you.

For example, if you have an NT 4.0 server, then (at the server console) launch the Administrative Tools, Server Manager, select your server from the list of computers, click the "In Use" button to display the locks, find the lock in the list for your .LDB file and click on it to select/highlight it, click the "Close Resource" button, and then exit the Server Manager. You should then be able to delete the .LDB file.

 

[Databaseguy]

If your admin cannot delete the file (which I have had happen), you're gonna have to re-boot the server.

In the future, make sure evryone has FULL permissions where the DB resides AND train your users not to exit improperly. (Ctl+Alt+Del, Hard Boot, Etc). Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[wgcs]

Why do you want to delete the LDB file? It will just get recreated. The LDB is used by MSAccess to manage multi-user access to the MDB by the same name. Basically, it stores "who has what record locked".