[AccessD] Access 97 - Numeric field overflow

No, I haven't gotten that far, though that will be next.  I defined the
fields that were double as long int, not int so anything up to +/- 2 billion
should go and I have visually looked at the data to make user none of the
fields exceed that.

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 4:34 PM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Access 97 - Numeric field overflow


Ok. I think it's time now to see the SQL your using for the append, and
perhaps a sample of the data that is resulting in the overload error. Have
you tried importing just one row or data each time? Importing one half of
the rows and then the other half? i.e. can you pin it down to a real error
of some sort in the data, like a double that is greater 2^16?

Lambert

> -----Original Message-----
> From:	John W. Colby [SMTP:jcolby at colbyconsulting.com]
> Sent:	Monday, March 31, 2003 4:08 PM
> To:	accessd at databaseadvisors.com
> Subject:	RE: [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
> > 
> 
_______________________________________________
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: 3288 bytes
Desc: not available
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030331/4afeb858/attachment-0001.bin>