Overflow - download from SQL

From: Greg Nelson (anonymous_at_discussions.microsoft.com)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 03:03:26 -0800

When I run a ADO query against a SQL Server database it
is really quick, no problem. I can loop thru all records
in the recordset (96,000 in this example). However when
I try and write the contents of this recordset into an
Access2002 table (using Addnew and Update) I get an
OVERFLOW error when I hit 32767 records. Doevents()
doesnt help. Any ideas anybody?

Relevant Pages