Allow linked tables to be set to Read Only
When building a system that shares its data with other systems - I've built an ERP system with Access - you often want to share certain Master data (from the HR system for example), but want to keep it that only HR can modify the data.
If we could set linked tables to be read only, that would remove the need for a lot of 'protectionist' coding.
David Harding
shared this idea
3 comments
-
ML
commented
Seems like bad security practice to have the client application protect the source data. A user could create a brand new link to the source database and modify it easily.
Instead, you can make a network drive read-only to some users, and put your HR database there. Or put similar read-only permissions on the HR database accdb file individually within windows file manager. Access can link to tables in a read-only ACCDB file, and it automatically becomes a read-only link in the client database.
-
Bob Walsh
commented
Having the ability to create read-only links to an access backend would allow me to ability to expose the backend tables to users to create their own queries without the fear of them corrupting the production data while giving them the most current data.
-
Klaus Oberdalhoff commented
if not an Access backend, but SQL Server or other, just use a query without primary key or unique index ....