making a table link read only

[philfer]

Hello,

I am creating a database which has several tables and one of them needs information from someone elses database.

I want to link the table in my database to theirs but I want to make the link read-only so that if I "accidently" change something in my table it wont mess up their database.

Is there any way to do this

Thanks
Phil

 

[Atomic Shrimp]

One way would be to link the table, then set up a query like this:

SELECT MyLinkedTable.*
FROM MyLinkedTable;

and in the properties dialog for the table, change the recordset type to 'snapshot', then only ever use the query in your application (you can also put a tick in the 'hidden' checkbox in the table properties dialog)