"Read-Only" : Security

[Charles Phillips]

Hello,
I have been given an MS-Access 2003 database to expand.
The database is on a server, with a "shortcut" on my desktop and another
desktop.
When I dd-click the shortcut on my desktop, I'm able to do whatever I want.
When ANY individual dd-clicks the shortcut on the other desktop, the
database responds with a "Read-Only" message.
I've tried to give the other User admin rights, but I must be doing
something wrong.
Can someone point me in the right direction, or some examples/samples...


Thank you,


Charles L. Phillips

 

[Joan Wild]

The read-only message may be a result of incorrect windows permissions on
the folder where the mdb is located. Users need read/write/create
permission on the folder, or the first person in will open it exclusively.

You might also be getting this message if you are trying to make design
changes while someone else is using the mdb. You need to split the database
and put just the backend (tables/relationships mdb) on the server. Give
each user a copy of the frontend (all other objects) on their workstation.