Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-23-2019, 11:29 AM   #31
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,253
Thanks: 15
Thanked 1,592 Times in 1,512 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Requery just ONE row from sql server

Sounds like a large table and no index on Group.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 09-23-2019, 11:13 PM   #32
sonic8
AWF VIP
 
Join Date: Oct 2015
Posts: 269
Thanks: 44
Thanked 76 Times in 73 Posts
sonic8 is on a distinguished road
Re: Requery just ONE row from sql server

Quote:
Originally Posted by CedarTree View Post
I created a pass-through query that mimics the Form recordsource, but also returns Row_Number. Then I run another query off the P-T query which grabs the RowNum that matches the criteria, then I go to that RowNum on the form. It runs relatively quickly.
Interesting idea. That simulates what Access/ODBC does automatically when using a linked table (or view) with a standard query in Access.



Quote:
Originally Posted by CedarTree View Post
I don't need a View, or indexing, etc.
I agree on you not needing a view. - When I suggested that, I assumed a complex query across multiple tables. - That is a very common reason for using a Pass-Through-Query.


However, I think indexing is the one thing you most urgently need! Put an index on tblPersons.Group in SQL Server and then check how your queries behave. - I guess this might solve your problem completely.

__________________
New article:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
sonic8 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server - ODBC - SQL Server Native Client Registry Bat File Rx_ SQL Server 0 01-28-2016 03:16 PM
Question How to "requery" tables linked SQL Server (ODBC) lake_tuna General 11 12-29-2015 11:42 PM
Link to SQL Server with ODBC without risking original data in SQL Server? David Ball General 1 08-21-2015 07:59 PM
SQL Server Linked Server to Oracle slow --> OpenQuery Solution Rx_ SQL Server 2 05-19-2015 08:25 AM
requery from the server hansnyc Forms 1 06-13-2007 09:02 AM




All times are GMT -8. The time now is 06:31 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World