[AccessD] Access 97 - Numeric field overflow

Drew Wutka DWUTKA at marlow.com
Mon Mar 31 14:15:35 CST 2003


The latest SP was 2b.

Not sure why you are having this problem though.

Drew

-----Original Message-----
From: John W. Colby [mailto:jcolby at colbyconsulting.com]
Sent: Monday, March 31, 2003 10:01 AM
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

----------------------------------------------------
Is email taking over your day?  Manage your time with eMailBoss.
Try it free!  http://www.eMailBoss.com


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list