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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by RWCMan
-
Union Query Into Linked Tables
Yes, I believe I have indexed all of the fields that should be indexed. Also, I am using this over a rather large network.- RWCMan
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Union Query Into Linked Tables
Thanks for your response. The expected number of records, depending on the situation for which the query is being run, could range anywhere from 2 to 1,500 records.- RWCMan
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Union Query Into Linked Tables
I'v set up a union query which works on a local table as well as a linked table in another Access DB. The number of records in the local is about 500,000 while the linked table contains about 1,100,000 records...the performance is horrible! I'm looking for some good tips on how to speed this...- RWCMan
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
