[AccessD] Access 97 - Numeric field overflow

Interestingly, I imported the data into A2K and the problem exists there as
well.  Truly weird.

In A2K I am at SP3 so I know I am up to date.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Heenan,
Lambert
Sent: Monday, March 31, 2003 11:13 AM
To: 'accessd at databaseadvisors.com'
Subject: RE: [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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



----------------------------------------------------
Is email taking over your day?  Manage your time with eMailBoss.  
Try it free!  http://www.eMailBoss.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 2860 bytes
Desc: not available
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030331/ebc1357e/attachment-0001.bin>