Server mdb

  • Thread starter Thread starter Golfinray
  • Start date Start date
G

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?
 
Golfinray said:
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?
Click to expand...

They need full permissions to the folder as well as the file.
 
Rick Brandt said:
They need full permissions to the folder as well as the file.
Click to expand...

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.
 
Back
Top