Problem with overflow in access module, when I debug goes to line incount = incount + 1. However I am not trying to read in anything below or above that access can't take
Posted on 2008-10-06
I have set up a linked table in access to link with a folder in my inbox to read in those messages. I am trying now to read the body of the message in the linked table to split it into Forename, Surname, Address and read this into a contact table with those three fields.
To look through the message I have :
intCount = intCount + 1
when I run the module I get error 6 overflow and it goes to the incount = incount + 1 line.
I only have one email read in the linked table to test so don't see how can be having overflow with too large bytes being read, so confused how to solve this, any suggestions would be appreciated.