I have a customer that upsized an Access 2002 application to a SQL2000 server. One of the converted make table queries which ran fine in Access 2002, now stops after writing 10,000 (10K) records to the new table (on SQL2000). Has anyone else experienced anything similar to this? We found if we append to the table, we can write 10K records per pass and get around the original limit. This append runs much more slowly and we would need to modify the overall code to make use of this appended table. The user is connecting to the SQL2000 server via ODBC under the 'sa' account. This would seem to indicate a configuration issue on the database side. Any insight would be great - thanks in advance!

Michael Franzyshe

This is a shot in the dark, but I seem to remember something in Access about
Max Records. If you are running the update from within Access using a select
statement, it will only pick the first 10k records for insert.

Could you try carrying out the insert from either QA or dts? These should
both insert the full amount of records...



--
James Goodman
MCSE MCDBA
http://www.angelfire.com/sports/f1pictures/
[quoted text, click to view]
server. One of the converted make table queries which ran fine in Access
2002, now stops after writing 10,000 (10K) records to the new table (on
SQL2000). Has anyone else experienced anything similar to this? We found
if we append to the table, we can write 10K records per pass and get around
the original limit. This append runs much more slowly and we would need to
modify the overall code to make use of this appended table. The user is
connecting to the SQL2000 server via ODBC under the 'sa' account. This
would seem to indicate a configuration issue on the database side. Any
insight would be great - thanks in advance!
[quoted text, click to view]