I have an Access database that has several SQL Server tables linked (though not used in any queries..instead I use pass-through queries). I am trying to create a report where the recordsource is a nested query where one of these pass through queries is used. Whenever I try to do anything involving this query I get an hourglass and have to wait awhile. When I am working on any of the queries I have to wait while even changing the query from Open (already ran) to Design view. It's like it has to run the query every time. It's even happen when I try to work on the report. If I go to delete a control on the report I have to wait. I am not sure why or how to fix it. Any ideas would be helpful, thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Performance Issue - Have to Wait B4 doing Anything
- Thread starter laakins
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
