When running the query as a select query, it displays quickly and I am able
to move to view the last record. I have been able to create a make-table
query from the same linked tables with fewer records. When trying to create
the make-table query for a whole month's worth of data is when it takes a
long time. So, maybe it is just that there is so much data that it is taking
a long time rather than it not working at all. If that is the case (I'm
letting the query run now), are there any settings that can be changed to
speed up the query?
MakeTable queries are inherently inefficient - Access must often guess
at field sizes, and even datatypes. Consider instead creating a
permanent table, with proper field types and sizes, and as few indexes
as you can manage (updating indexes can be a bottleneck). Rather than
deleting the table and running a MakeTable monthly, empty the table
with a Delete query, compact the database, and run an Append query
from your Sybase data.
John W. Vinson[MVP]
