Server mdb

[Golfinray]

I have not split my one database yet although I'm going to. Just a question.
Right now I have the MDB file on a simple file server that everyone uses. It
is mapped as a p: drive. I don't have any security set up yet other than to
give rights to my managers. They have delete, edit, read, write and so forth.
Still if two people try to work in the same file, the one who got in there
second is read only. Is that normal? How can I make it where anyone of the
managers or all can be in the file and edit at the same time? Is that the
correct procedure? Do I need to go ahead and split?

 

[Douglas J. Steele]

They need full permissions to the folder as well as the file.

I've actually heard of cases where the users have the ability to create or
delete the locking file (.ldb) in the folder, but not to update locking
files created by other users. Check that that's not the case here, because
the first user in will create the locking file, and subsequent users need to
update that same locking file.