We have a MS SQL 2005 server
I have and Access2000 table with 9 million records. (HISTORY)

I created a table on the SQL and linked it into an Access .MDB (HISTORY_OLD)

When ever I use an append query to copy History into history_old I get errors.

I tried to upload a million records at a time.  that works but it is slow. 
1 hour!!!

Why does it take so long?
Is there an Access setting that makes windows work better?
Help
Scott Burke

Update Statement
Date Range
SQL query
xp_cmdshell - works with string in one format but not in another -
How to concatenate strings from a column into a single row (with NULL value)?