Read-Only problem

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have created a MDB file.
I put it on a network drive and gave full control on it to everyone.
It`s working fine with my user (admin), but with regular users I get "The
database"name" is read-only".

What`s wrong?

please help, thanks,

Tom
 
Are you sre they have full acces to that folder on the LAN?
They must be able to read, write, and delete.

Rick B
 
Hi Rick,
Thanks for your response.
The permissions on the folder is "list folder contant",
which allow them to read and write.
in the same folder i have other DB that works fine.

Thanks,
Tom
 
That's not enough.

The users need Create / Read / Write / Delete permission on the Folder
propagated to child objects in this Folder.

The reason is that the user needs to be able to create and to delete the
locking file .LDB as well as to read and to write to the database file (.MDB
/ .MDE) as well as the locking file .LDB.
 
Thanks for your response, it make sense,
how do I prevent the user go into the folder and delete the MDB file and
still use it?
Thanks,
Tom
 
Tom said:
Thanks for your response, it make sense,
how do I prevent the user go into the folder and delete the MDB file and still
use it?
Click to expand...

Frequent backups and a large stick?

This is one of the downsides to using a file-share database. You can be pretty
strict with non-users of the file, but a legitimate user CAN delete the file.
 
Back
Top