Append Queries in ACCESS 2000

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

Guest

Am using an Append query in a database that has been converted from ACCESS 97
to ACCESS 2000. The query examines a table via ODBC and appends results to a
table in my ACCESS database. Using 97 this used append > 100k records in no
time. In 2000 the query hangs. Any suggestions would be welcome.
 
Connor,

Why don't you post the SQL, that way someone may be able to spot the problem.

Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2010 append query to SQL is very slow 0
Append Query Issue 0
Append Query 1
Append ODBC tables into Access Table 5
Schedule Auto run Query on append table 0
Append query in Access to SQL Server 2
Access 2002 Append Query Problems 1
Append Query is not working 1

Back
Top