OVERFLOW error

[Greg Nelson]

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?

 

[Douglas J. Steele]

Sounds as though you're adding a record number field when you're inserting,
and you've set that field to Integer, as opposed to Long Integer.