OVERFLOW error

  • Thread starter Thread starter Greg Nelson
  • Start date Start date
G

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?
 
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.
 
Back
Top