How do I link a table in read-only mode

[gjoverto]

I have an Access 2003 database that is updated frequently and one of my
co-workers needs to access one of my database tables in his database, but he
doesn't want to accidentally modify my data. How can we link the table he
needs into his database as a read-only table?

 

[Rick Brandt]

I have an Access 2003 database that is updated frequently and one of
my co-workers needs to access one of my database tables in his
database, but he doesn't want to accidentally modify my data. How
can we link the table he needs into his database as a read-only table?

Use a query with the IN clause instead of a link and then set the
RecordSetType of the query to Snapshot. That will make it read only.

SELECT * FROM TableName IN 'Path to your mdb file'

 

[Douglas J. Steele]

Short of applying security, I don't think it's possible.

What you can try, though, is to create a query that uses the IN
externaldatabase syntax, and make the query non-updatable using SELECT
DISTINCT:

SELECT DISTINCT Field1, Field2
FROM MyTable IN \\server\share\folder.file.mdb
ORDER BY Field1