Question Locked

Access 2003 Database opens Read-Only!

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I have an access 2003 database that is shared on a network folder. A user with Read-Write access can open the database fine as long as no-one else has it open. If another user opens it with Read-Only access then the user with Read-write access opens in RO mode. A .ldb file is created though but the option to save is greyed out. When I look on the server to see what files are open I see RW user has the file open and there are 2 entries. One is with RO access and the other is with RW access. I moved the database to a local hard drive and I still have the same issues.

2 replies

by jajuoga

if you are working in a windows2003 server environment then , goto administrative tools and file server management , then look at shared folders permissions you will see that it has been set to read only.. select change or full then click ok this should work for you.

This discussion is closed to new replies.