Are all MS Access 2003 Pass-Through Queries Read-Only? 1

[steve728]

When using pass-Through Queries via Access 2003, are ALL the returning results read-only. Can I not process transactions via this ODBC connection?

I'm also using SQL Server 2000. Are there any problems doing the same thing with SQL SErver 2005 Express?

Steve728

 

[lameid]

Yes, read only.

Sql Pass through (SPT) queries send an SQL statment to the server. So if you send a select statement, it returns a dataset that is not updatable. You could write an SPT that performs an insert or update as well.

Also noteworthy is that you can link a table or a SQL server view as a table in Access and treat it like a native table. This will be slower than even doing the same operation in Access natively but it is functional. That is it is slower unless you use a Access Data Project (ADP) in which case by definition all your queries hit SQL server directly anyway. Having made an ADP, I suggest it may be easier to stick with Jet unless you have a convincing argument for SQL server.