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