Quick question on hoqw queries work in MS Access

[itm]

Hi,
My company is concerned that if I even query data on a SQL Server through linktables that I can be changing the data in some way on the SQL Server. Now I amnot talking about ADD, update, or delete queries; I know these would change thedata naturally.
I am wondering how queries work when I create a query that queries a table thatis linked to SQL Server through MS Access that is using a linked table. Myunderstanding is that because Access is a file based system, it is bringing thetable data down to be viewed in Access and that is it. AM I right in myunderstanding here?



Also if I am right, does it make a difference if we are talking about a passthrough query or doing this through DAO, ADO in VBA code. Thant is if I am writing SQL to just view data can I do an harm to the data in some way here?
Thank you

[R_Badger]

Using a select query should not change the data, unless you actually manually change it yourself (I haven't worked with SQL server myself but the principal of operation should be the same)

Since this is so easy to do whilst having an open query with Access (knocking a key etc), generally people who are worried about it (myself included) build a form to view the data and lock all the controls on the form, thereby preventing any editing taking place.