Securing .mdb and .mdw Files On A Network Share Location
Posted on 2009-05-14
We have user-level security setup on our frontend and backend .mdb files.
However, the backend is located on a network share location so all users can link to the database when they start their local copy of the frontend (which they also copy from a network location).
I want to know:
1) Is their is anything more I can do to stop users copying / deleting / moving the frontend and backend .mdb and .mdw files?
2) If so, what permissions would I need to set on the server?
I'm just getting 2nd opinion as in the book I've been reading, "Alison Balter's Mastering Microsoft Office Access 2003 by Alison Aalter, p.53) it says:
"An additional weakness is that the network share where the Access .mdb and .mdw files are located also needs to have read, write, and delete permissions, which means you can't prevent users from deleting or copying the .mdb and .mdw files. The only alternative is to create an n-tier application where the middle-tier objects alone have access to the physical files. However, this means that you need to write the application "unbound," since the users will no longer be directly connected to the database. When you get to that point, you'll probably be considering SQL Server or another database platform that is capable of scaling to support more users and larger volumes of data."