Solved: Link tables Security

[blastpwr1970]

HI,

How do I prevent linking to my tables from another database?

The problem I have is that I created a link from another database and I am able to change the data from the second database even do the first database is password protected.

How can I have updated information on the second database without changing the data on the first database via link?

[OBP]

Julio, invoking the Database password is not the same as "Securing" the database with the security wizard. Presumably you could set up an account for opening the database from the "linked" database which has "Read Only" rights and have another account which is used to update the data in the database.