Access2002 db to db read-only table links?

[cmgrn]

I would like to give someone in our company a database with links to important tables in our main database so he can query and report until his fingers drop off ...BUT... I would like the links to be read-only so he cannot accidently alter and/or destroy the base data.

I do not use any access security beyond a database password and some vb programming because I do not understand those workgroup files and do not want to mess up and lose a database because I am permanently locked out.

That is why I am looking for a linked table connection option or parameter (if one exists) to make the links read-only.

Thanks for your help in advance.

 

[Remou]

As far as I recall, you can do this by putting the database in a folder to which he has only read permissions.