Read-only access to linked tables

[inf33323]

Hi all,

I have a Access2000 database and I use two linked tables in it. Anybody using my database can add, delete and update recods in the linked tables. I would like to hinder this and to guarantee only read-only access to them.

Would appreciate any idea.

Thanks,

inf33323

 

[tomschafer]

You would need to lock down security on the other side. i.e. for SQL Server.
REVOKE DELETE, INSERT, UPDATE
ON [Table Name]
FROM [User Names]

 

[Ed2020]

Use the MS Access User Level Security Wizard and remove edit, delete and add data permissions on all of the tables from the admin user.