[AccessD] Access 97 - Numeric field overflow

JC,

You got me confused when you say "The append process works the first
time it is run, then the second time, I get a Numeric Overflow."  What
are you doing the second time?  Appending the same data to the same
records, or appending some other data to some other records, or what?

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: John W. Colby [mailto:jcolby at ColbyConsulting.com] 
Sent: Monday 2003 Mar 31 10:01
To: AccessD
Subject: [AccessD] Access 97 - Numeric field overflow

Guys,

It's been awhile since I have dealt with A97.  I am doing an import of
data from excel spreadsheets.  The data in the spreadsheet is a dbl
datatype, but is really a long int, i.e. no decimal points.  I am
linking the spreadsheet, whereupon I see that the datatype of the field
is dbl.  I build a base query that runs these fields through a clng() to
convert them to long integers.  I then append the data into a table.
The append process works the first time it is run, then the second time,
I get a Numeric Overflow.  I get the overflow between the "you are about
to..." warning and the "X records did not append..." error.  In fact
that second error never occurs.  Once the error occurs, I have to shut
down the db and re-open it, whereupon the query will run successfully
one time, then the error again.

I am at SP2 for A97, and I don't remember what the latest SP is for A97.

Has anyone ever seen this problem?

John W. Colby
Colby Consulting
www.ColbyConsulting.com