Access 2003 - Select Query Fast But Append or Make Table Query slow
Posted on 2006-06-06
I have a select query that uses ODBC to retrieve from a Sybase database. The select query completes in about 5 seconds. There are about 3000 records. When I run the same select query as an append query or a make table query (to a local Access table), the progress bar moves halfway in about 5 seconds (probably indicating that the query has completed) but the query hangs at that point. The 3000 records never make it into the destination table. Any ideas?