Create a read-only link to SQL db

[PearlGI]

I've got an Access frontend that I need to connect through to a SQL db (using SQL authentication). However, I wish to make these links read-only to prevent accidential changes to the data.

I can't seem to find a way to do this using the normal link table option and can only assume it has to be done via code (assuming it is possible).

Can anyone help or provide some sample code?

 

[Pat Hartman]

You need to use SQL security. Have the DBA set up a special account that only allows read access. Use that account to link the tables. They will be read only. If you need both read-only and update access via your db, you can either have separate SQL server logons for each user or you can control the swapping between accounts behind the scenes.