Access Overflow error


Joined
Aug 31, 2016
Messages
2
Reaction score
1
So at my firm, we run updates everyday through our access database, which is built off of query upon query upon table upon query. I didn't build it, but when running one of our updates, we got an overflow error which has never occurred before Monday. I ran through all of the queries and found the query that wouldn't run and tried to convert everything to long data-types with the CLng function. That didn't work. So I tried the CLng function with the Nz function and that still didn't work. Then I tried removing individual pieces from the query to see if one of them was causing the error, and that didn't work. I am running out of ideas on how to make it work. Any help would be greatly appreciated.

I should also say that the query is pulling from another query that pulls from a .csv file and another table in access.

Thanks in advance for your help.
 
Last edited:
Ad

Advertisements

Joined
Jul 11, 2010
Messages
5,758
Reaction score
552
Welcome to PCR sbraun27 enjoy the site and join in. I cannot answer your question but I am sure some of our more techie types may be able to help you.
 
Ad

Advertisements


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

Top