Dec 15 2011, 03:32 PM
I have an MDB located on a networked hard drive. The database only allows one user to open it in spite of the advanced options set to:
Shared - checked
Default record locking - No records - checked
Open databases by using record level locking - unchecked
I have decompiled and "compacted and repaired" this database, but still only one user can open it. Please tell me how to allow multi user access.
Thanks in advance,
Dec 15 2011, 03:39 PM
You should split the database.
That means (and you have a function to do it automatically) your Backend (tables) are on the network share.
Your Frontend (queries, forms, reports) are on each user's machine.
The network share must give read/write/edit/ and delete rights to each user.
Also, set record level locking to edited record. That way only the record that is being edited is locked and the others are open.
Dec 15 2011, 04:27 PM
Here's a link to the Wiki article that explains what Milton was talking about: Splitting
Just my 2 cents...