Discussion Locked

database only opens read only from LAN

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a MS Access database created from Office XP, saved in Access2000 format, with multi-user acounts and pindividual permissions that is replicated. My problem is that the database will only open as read only from computers other than the one it was created from. I have already set up a workgroup file on the server, and that did not fix the problem. I've basically tried everything I can think of over the past 2 months, and can't fix it. Can anybody help?

4 replies

by otl

open the database on the server and check tools -> options -> advanced ensure shared is checked (not exclusive). Also check that only the edited record is locked or no locks with the open the databases using record level locking is on.

by otl

Not happy hit tab key then enter and toggled back to where I started.

Have you checked (in program mode) tools -> advanced -> default open mode is shared ? And locks are no locks ? And under the Table/Queries tab that run permissions are users no owner's ?

Did you create an MDE ? If so this will have options to LOCK DOWN the Database.

This discussion is closed to new replies.