Discussion Locked
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 hwinter5
Poster rated this answer.
I already did that. Sorry, I need more than that.
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.
by hwinter5
Poster rated this answer.
I've already tried all of those. Thanks anyway.
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
Discussion
Useful software Tip or Shortcut
0 helpful
1 reply
Question Unanswered
Best Low-Latency VPN Protocols for Competitive Mobile and Online Gaming
0 helpful
0 replies
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies