LDB not being removed

[Jake F]

I have a split DB that for a few users on occasion, the ldb file for the back
and front ends are not being removed. They're updating employee data by
clicking yes/no in an option box and they have one or two employees that lock
up and cannot be updated. The next day the file is removed, but restarts and
closings have not worked so far. I'm not sure if anyone knows some possible
reasons the records are locking up? Thanks.

 

[Jerry Whittle]

The most common reason is that all the database users need Read, Write,
Create, and Delete privileges to both the database files and the folders
where they are located. If a user doesn't have Create privileges, that user
can't create the .ldb file which might lock out other users. If users don't
have Delete privileges, then it won't be removed after the last user exits
the database.