MS Access Network Permissions
Does anyone know what permissions are required to update or connect to linked tables in MS Access 2003?
I have basically two user level security groups; 1 for administrators and 1 user level. Admins have full permissions and have no problem updating linked tables. The user group has read / update / delete permissions for data and open / run permissions for macros and reports.
source to share
Sorry, I have to read the MS Access help files first;)
In general, if you want users to have access to a linked table (linked table: a table stored in a file outside of an open database from which Access can access records. You can add, delete, and edit records in a linked table, but you cannot change its structure.), give them the Read Data and Read Create Permissions data on the table in the back-end database, and allow the change of permission to the reference in the table defined in the front-end database so they can conveniently reset table. If you want to restrict all access to the internal table but still allow users to view the data and reassign tables,remove all permissions in the background and use queries on the front-end database with their RunPermissions property on the owner.
source to share
If you want to update or connect to access linked tables via VBA, there is a VBA add-in that you can download from -> Access linked VBA table add-in
This allows you or your users to communicate when you need it and, if necessary, multiple databases
source to share