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
469 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 - Access MVP) earned 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

813 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now