Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2013-05-28
4
Medium Priority
?
475 Views
Last Modified: 2013-05-29
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
Comment
Question by:Douglass MacLean
  • 2
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 2000 total points
ID: 39203509
By definition, pass through query cannot be updateable.

mx
0
 

Author Closing Comment

by:Douglass MacLean
ID: 39203607
I hate the answer, but I love the unvarnished truth.
Thanks much.
0
 
LVL 75
ID: 39203618
lOL ... as a side note, this is worth reading:

http://allenbrowne.com/QueryPerfIssue.html

mx
0
 

Author Comment

by:Douglass MacLean
ID: 39203749
That's useful, mx. Thanks.
Doug
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question