I have a database on a shared network drive. All users except the manager have only read access to the file/directory. However, if the manager tries to open the file while other users have access open, it only allows him to read it as read only. If they close the database, then he can open it with read-write. Does access use another mechanism other than ldb files for locking?
The weird thing is that it seems to be locking correctly. If the manager tries to open the file while someone has it open, it's read-only. If he tries to open it once they close the database, it isn't. I tried it myself