9 replies
by bchesmer
by suvefx
by acurrin
The LDB file is only there to maintain proper database locking during use. If you give full rights to the folder, but read-only rights to the MDB file, Access should be able to create and modify the locking files, while leaving the DB alone.
Good luck
by suvefx
by rogerndgreen
I have had a similar poroblem at work, and unfortunately in my case, providing only RF rights meant that the users could not open the database (Access required the "traditional" RWCEMF before it stopped complaining). In this case, I had to go down the route which you have already rejected in the first answer, and use Access's built-in security to provide the different level of protection. It's not ideal.
Depending on how "real-time" you want the read-only users to be, you could create a copyof the actual DB, give them the rights they need (if they modify it, it's their fault) and then use toolbox & cron to schedule a regular job to overwrite this copy with the "live" one.
HTH
Roger
by suvefx
by isys
by suvefx
by suvefx
This discussion is closed to new replies.
Trending Networks posts
Sort by Trending