Re: OVERFLOW error
From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 03/17/04
- Next message: Foxy: "Importing XML files"
- Previous message: Greg Nelson: "ignore Overflow problem"
- In reply to: Greg Nelson: "OVERFLOW error"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 17 Mar 2004 07:05:09 -0500
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.
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (No private e-mails, please) "Greg Nelson" <anonymous@discussions.microsoft.com> wrote in message news:eab201c40c0f$aed78860$a501280a@phx.gbl... > 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? >
- Next message: Foxy: "Importing XML files"
- Previous message: Greg Nelson: "ignore Overflow problem"
- In reply to: Greg Nelson: "OVERFLOW error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
