[AccessD] Access 97 - Numeric field overflow

Jim Lawrence (AccessD) accessd at shaw.ca
Mon Mar 31 12:46:38 CST 2003


Hi John:

You have not exceeded the maximum of 65000 records by any chance?

Just a thought
Jim

>  -----Original Message-----
> From: 	accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] 
> Sent:	Monday, March 31, 2003 9:09 AM
> To:	accessd at databaseadvisors.com
> Subject:	RE: [AccessD] Access 97 - Numeric field overflow
> 
> In fact I was just appending the same data twice.  I have a unique index
> on a combination of fields that should prevent the data from going in a
> second time.  This was just a test of that index to make sure the data
> would not go in again.  
> 
> In fact though the user may end up importing several different files, one
> after another.  The entire process is to ask the user to find the file,
> copy it to a specific file name in a specific directory so that the link
> works correctly, copy the original to a backup directory, then run the
> append queries to get the data out of the spreadsheets and into the table.
> From there a "all records in the previous" and "all records NOT in the
> previous" will be run for reporting purposes. 
> 
> It shouldn't matter what I am doing though.  If it runs once, it should
> run a million times.  It may very well come back and say "X records could
> not be appended..." because of the unique index, but it should NOT give me
> this "numeric overflow" error.  According to help that means that "the
> data is too big for a btrieve field" or some such.  IOW, one of those
> useless error messages.  The fact that the data actually imports makes it
> even more suspicious.  
> 
> I just don't want to send out work that pops up useless error messages and
> has to be exited and reloaded in order to work.
> 
> 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 Wortz, Charles
> Sent: Monday, March 31, 2003 11:11 AM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] Access 97 - Numeric field overflow
> 
> 
> JC,
> 
> You got me confused when you say "The append process works the first
> time it is run, then the second time, I get a Numeric Overflow."  What
> are you doing the second time?  Appending the same data to the same
> records, or appending some other data to some other records, or what?
> 
> Charles Wortz
> Software Development Division
> Texas Education Agency
> 1701 N. Congress Ave
> Austin, TX 78701-1494
> 512-463-9493
> CWortz at tea.state.tx.us
> 
> 
> 
> -----Original Message-----
> From: John W. Colby [mailto:jcolby at ColbyConsulting.com] 
> Sent: Monday 2003 Mar 31 10:01
> 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 << File: ATT00050.txt >> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 3688 bytes
Desc: not available
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030331/1826bb48/attachment-0001.bin>


More information about the AccessD mailing list