Protecting Linked Tables

[Wet_Blanket]

I have a newb question. I've never set up my own database before, just used what was there, and just finished linking tables into the new database from a SQL Server. Question, is protection needed on these linked tables so that users can mess up the original data from the server, or is this just a one way street?

I do not want any editing of original data, just use it for querying purposes.

 

[pbaldy]

I would create a read only user in SQL Server, and link the tables using that user.

 

[Wet_Blanket]

I would create a read only user in SQL Server, and link the tables using that user.

Will do. Just to confirm, deleting these linked tables from my database (to make a read only user) will have no effect on the original tables on the server?

 

[MSAccessRookie]

Will do. Just to confirm, deleting these linked tables from my database (to make a read only user) will have no effect on the original tables on the server?

You may not need to delete them at all. You should be able to create a new Resource (ODBC?) that uses the Read Only ID to connect, and use the Linked Table Manager to switch the connections to point to the new Resource.

 

[pbaldy]

Correct; you're just deleting the links to them.