• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 477
  • Last Modified:

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?
0
Douglass MacLean
Asked:
Douglass MacLean
  • 2
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now