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
467 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:dmaclean2
  • 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:dmaclean2
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:dmaclean2
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.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

911 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

21 Experts available now in Live!

Get 1:1 Help Now