front-end/back-end multi-user problem - 08-25-2005 , 04:40 PM
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??