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.
31
votes
David Harding
shared this idea
2 comments
-
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 ....