I have an Access 2002 database with user-level security that is split into a front end and back end. When I'm logged into the network as administrator, everything works great. When I'm logged into the network as a user, I get different messages. If I try to log into the database using a "full permissions" account, it tells me that the database is read-only and then opens the db. If I try to log into the database using a "read-only" user account I get a "could not lock file" message and the db is not opened. What's going on?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
"Could not lock file"
- Thread starter ashows
- Start date
If you've got permissions on the network folder (like certain people are allowed into the folder), check those. I spent several days trying to figure on a "locked file" error, and it turned out that I missed on permission on the folder.
Linda Adams
Linda Adams/Emory Hackman Official Web site Official web site for actor David Hedison:
Linda Adams
Linda Adams/Emory Hackman Official Web site Official web site for actor David Hedison:
- Status
Similar threads
- Locked
- Question
- Locked
- Question