Will a simple Passthrough Query from Access 2010 to SQL Server to retrieve a few records from a large table be Updateable?

I have a situation where a query that results in 1-15 records to be processed in an Access  2010 form,. It transmts 1.2 million records from SQL Server to the Access database engine and then throughs away all but the few that are needed.

If I replace it with a Passthrough Query and specify that passthrough query as the form's RecordSource, will the query be updateable so that the user can enter and change data in the rows of that query in the Access form?
Douglass MacLeanCTOAsked:
Who is Participating?
Advertise Here
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
By definition, pass through query cannot be updateable.

mx
0
 
Douglass MacLeanCTOAuthor Commented:
I hate the answer, but I love the unvarnished truth.
Thanks much.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
lOL ... as a side note, this is worth reading:

http://allenbrowne.com/QueryPerfIssue.html

mx
0
 
Douglass MacLeanCTOAuthor Commented:
That's useful, mx. Thanks.
Doug
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.