[AccessD] Access 97 - Numeric field overflow

Well, whenever I start getting inconsistent behavior such as you describe,
I'm, inclined to backup the Db and then decompile it, compact it and repair
it. With luck that will sort it out. SP2 is the latest for A97, AFIK.

Lambert

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