LDB File

[PaulJK]

I am not sure if my understanding is correct, but here goes.

We have a database which is split FE & BE over a network of five users. Everything has been running smoothly until just over a week ago.

At that time the database slowed considerably. The only thing we noticed was that in the directory where the FE is on the users PC's there is a new LDB file which has the same name as the Workgroup Information File which is located on the server!

The only LDB files we had resided on the server when someone was connected to the db and the file disappeared when no users were logged on.

I presumed this new LDB on the FE PC's needed to be deleted but the file cannot be deleted or opened, even when all users are logged off the database.

Any assistance would be appreciated.

 

[ghudson]

The ldb is the record locking file. That is normal to be were the db is located. The ldb should delete itself when the last user of the program closed the db. If not, reboot all PCs that use the db and then you should be able to delete the ldb file. You can open the ldb file with a text editor like Notepad.exe and it will list the computer names for each user who has been in the db.