Software

Ask something
Discussion Locked

MS Access - numeric field overflow error

0 helpful
3 replies

by cdruman

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have created some make table queries in MS access 2000 that create Tables based on Linked MS Excel files. I can create the tables Once. however consequent attempts to run the query give a message "numeric field overflow" and I cannot continue. Would appreciate some assistance here. thanks

3 replies

by dklippert

There's a Knowledge Base article about this. Type the following in the address box of Internet Explorer:

MSKB Q223225

One of the reasons given involves dates before 1/1/1900

by cdruman

Doug, appreciate the answer but I checked the knowledge base first. doesn't seem to correspond with the steps I am taking prior to getting the error.

by camcc591

My experience does not include "numeric field overflow" but I have had realy screwy behavior from Access97. For example, "Function Nz not found." (Yes, this is the Access built-in function that cannot be found.) I can usually get rid of these oddities by compacting. On occasion, I have to open a new, blank database and copy everything from the original into the new - then delete the original.

Perhaps something like this will help.

This discussion is closed to new replies.