Numeric Field Overflow

M

Mike

I am trying to run a make-table query which has limited data from an excel
file. It errors out and gives me "Numeric Field Overflow". However, when I
compact and repair the database, and re-run the same query, its fine and
actually makes the table. Is there a way to avoid/correct this?
 
J

Jerry Whittle

You may have a corrupt database.

Tony Toews has an excellent web page on database corruption.
Http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
Http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database.
Click on "Whittle, Jerry" on this page:
http://www.rogersaccesslibrary.com/forum/default.asp?C=1

Also I'd make sure that you have the latest service packs for your version
of Office and Access.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numeric Field Overflow Error 5
Numeric overflow 2
The Numeric Field Overflow error with linked tables 2
Numeric Field Overflow when appending date - how to convert it to text 1
Numeric field overflow error on date field 3
Numeric Field Overflow from Excel File to new Table in Access 4
Using query to make a table 3
Access 2000 Numeric Field Overflow 3

Top