Lockfile in ldb

[TCerven]

Does anyone know what lockfile.9 for my ldb means? I have been crashing because the network database continues to lock-up in the ldb file. Even after everyone logs out I still show an open ldb. My admin has looked at it and told me that it isn't the server it is the software.

When this happens the users get a message that says the the system doesn't recognize the database. The only way I have been able to deal with this is to have the users exit out of the program then I have to delete the lockfile.9 ldb, run repair and then have them log back into the database and continue. Help! I don't know how to fix this one.

 

[DougAtAvalon]

Not sure if i am clear on your problem. Anyway two thoughts:

1. As a quick fix if you're using NT Press Ctrl-Alt-Del for "Task Manager" and stop instance of MSACCESS.

2. Get the MS Office SR2 update. They do list this as a fix there.

-Doug

 

[scking]

The .ldb file is a locking file created to store computer andsecurity names and to place byte range locks on the recordset. It is automatically deleted when the last user exists the database file except:

1) The database is marked as damaged.
2) The last user out doesn't have delete rights in the folder with the database and .ldb files.

The .ldb file information prevents users from writing data to locked pages. When a user exits his/her info remains until overwritten by the next user.

Hope this helps.

Steve King Professional growth follows a healthy professional curiosity