Link to SQL Server with ODBC without risking original data in SQL Server?

[David Ball]

Hi,

I want to create an Access database that sources data from a SQL Server database and then use the Access database independently for different purposes. I would like to be linked live to the SQL Server, via ODBC, so that info is always current but don’t want any risk that the data in the SQL Server database is changed in any way.
Can I link to SQL Server using ODBC in such a way that I can’t possibly delete or modify data in SQL Server when I change things in my Access database?
Thanks very much

Dave

 

[pbaldy]

Sure. Link using either a SQL Server or Windows user that has read only permission to the data.