LDB lock on myself (1 Viewer)

I have a database (2003 format) that keeps telling me I cannot compress, make changes, etc. because another user is in it but the user it reports is me. No matter what I do this keeps happening. If I leave it alone for a few days it will finally allow me to delete the ldb file but there are 40 users on this and that's not always practical.

Any idea what does this?

Are you opening this as a "shared" file on a network location? You really should have it as a split database (frontend on each user's machine and backend linked on the server).

Then you distribute a new frontend to other users either manually or by using a tool like my free frontend auto update enabling tool (Tony Toews also has one). You can find mine here:
http://www.btabdevelopment.com/main/MyFreeAccessTools/tabid/78/Default.aspx

Is the application split into a front end and back end?

Does each use have ther own copy fo the front end that is not shared?

If, NO to both, then your error is normal because your database is not properly set up for a multi user environment.