HELP!!!!!! RUNTIME 6 ERROR "overflow"

[madetoheal13]

Hey all! I am getting a runtime 6 error message "overflow". My database was working fine, and then I replicated it. Now when logging out on a replica...before closing...this message pops up. All updated info..is updated and kept in the tables. But updated info does not show up in reports. Any clues?

Thanks.
Madetoheal13

 

[PHV]

No division by zero ?
No huge number stored in too small data type ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PHV]

I guess the problem is with AutoNumber fields.
Before replication: Long (4 bytes)
After replication: GUID (16 byres)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PHV]

After more investigations the new AutoNumbers aren't necessarly GUID but random Long.
I suspect an Integer variable you should dim as Long.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886