noidentity29
New member
- Local time
- Today, 09:16
- Joined
- Dec 14, 2009
- Messages
- 2
Hello,
I have a client who built an Access '97 application years ago and has upgreaded it through the years to Access 2007.
She has recently moved the data from Access to SQL Server and is linking to the table. The queries are now taking an incredible amount of time to process. It looks like Access is pulling back all of the records one at a time. The bottleneck does not appear to be in SQL as we are monitoring it through SQL trace. There is way more activity than expected.
Is there a way to optimized the 'Find' command button so that the search queries run faster?
Shannon
I have a client who built an Access '97 application years ago and has upgreaded it through the years to Access 2007.
She has recently moved the data from Access to SQL Server and is linking to the table. The queries are now taking an incredible amount of time to process. It looks like Access is pulling back all of the records one at a time. The bottleneck does not appear to be in SQL as we are monitoring it through SQL trace. There is way more activity than expected.
Is there a way to optimized the 'Find' command button so that the search queries run faster?
Shannon
