Linked tables and SQL Server data

[Guest]

I've set up a desktop database on my computer to improve the efficiency of my
company's report writing and it's all working just fine. I'm the only one
that uses the database etc. I opted to import the tables I'm using directly
into Access because I'm pretty new at doing this and linking to a live SQL
table looked too intimidating. My problem is that I would really rather
create a link to the SQL server (which I have done successfully as a test)
and run my queries against these tables, but I do not want to ever change the
table data in the SQL sever and I just don't want to run the risk of doing
something wrong that may cause issues with the table data at the server
level. Is there anything I can do to have the benefit of using live linked
tables, without the risk of messing up a table on the server. Perhaps a
read-only setting or some other barrier. Any help would be so appreciated
and thank you.

 

[Douglas J. Steele]

You could create pass-through queries that retrieve the data, rather than
using linked tables. Pass-through queries are read-only.

 

[Aaron Kempf]

Linked Tables have been depecratd, you should be using Access Data Projects

file, new, Project (existing data)

anything else is a waste of time

 

[Aaron Kempf]

pass thru queries are a pain in the butt

use Access Data Projects

in MDB it takes about a dozen lines of code to bind a form to a sql
passthrogh and uses a sproc with parameters.

In ADP it takes ZERO coding

 

[Guest]

You can ask for a separate login for SQL Server,
that has only read permission to the tables