make table query hangs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 03/WinXP. When running a make-table query, the query just hangs - no
errors. When running the same query as a select query, the data displays
properly. The query is based on linked tables - Sybase. Any suggestions???
 
Hi,
When you run the query as a select query, can you scroll to the last
row?? I think that you might just have a very long running query.
 
Access 03/WinXP. When running a make-table query, the query just hangs - no
errors. When running the same query as a select query, the data displays
properly. The query is based on linked tables - Sybase. Any suggestions???
Click to expand...

How big is the table? Are you using the query to import a Sybase table
into Access (in which case File... Import might be better), or are you
trying to create a new Sybase table? More details please!

John W. Vinson[MVP]
 
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?
 
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?
Click to expand...

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]
 
It took about 30 minutes for the make table query to create a table with 51
records. What suggestions do you have to speed this up?
 
It took about 30 minutes for the make table query to create a table with 51
records. What suggestions do you have to speed this up?
Click to expand...

See my answer posted 12/19.

John W. Vinson[MVP]
 
Back
Top