I have a "front-end/back-end" database distributed as two .MDB files:
client.mdb and server.mdb. client.mdb has all the forms, queries,
reports, and code. server.mdb has only tables. client.mdb
dynamically links to the server.mdb tables at startup.

Since I don't need multi-user write access to the data, I just dumped
both .MDB files onto a file share accessible from all users. My
understanding was that this would work because when the first user
opens the client.mdb file, this would result in the creation of a
client.ldb file on the shared folder and subsequent openers of
client.mdb would have read-only access because of the .ldb file.
Perhaps I am wrong in this assumption.

When user A opens and closes client.mdb everything works fine. If
user B opens client.mdb while user A has it open, they get a read-only
version. That's good.

The problem is that even if user A closes client.mdb then afterwards
when user B tries to open clieint.mdb he still gets a read-only copy
even though the client.ldb file is no longer on the shared folder!

Can someone help explain this??

Thanks