Marking a linked table as read only 1

[dapotter]

I have an access database whose primary purpose is to allow viewing of data exported from a different database management system. The other system is cumbersome to use, so the Access database allows querying and reporting in a more familiar manner.

Because the Access database is intended to be read-only, I would like to mark the linked table as read-only. The source file is updated periodically, so any changes would be overwritten. I would like to prevent changes in the first place so people don't think they've committed a change to the source database. Is there a way to do this?

 

[KenReay]

Hi

Hide actual tables from users

Allow users access to the data only via forms (with control .locked properties set to true), of via queries which may be run in readonly mode, in otehr words hide the raw data from the user(s)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK