Table link read only?

M

matjcb

I have a database that is linked to another database table.
Is there a way to make this link a read only?
 
D

Douglas J. Steele

Rather than a linked table, consider having a linked query. If you use the
keyword DISTINCT in the query, it won't be updatable.

To create a query that's linked to another database, use SQL like:

SELECT DISTINCT Field1, Field2, Field3
FROM [;Database=E:\Folder\File.mdb].Table
 
Top