hi all,
i'm having problems with an overflow error (6).
it only happens when more than one user is connecting to the back-end.
records in a table are accessed and edited my multiple users and it
seems to fall over when more and more people connect to the BE.
any suggestions ??
joe
Amy Vargo - 22 Dec 2004 20:02 GMT
Hi,
My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.
Do you have any code that runs? I have seen this error if you declare a
variable as an Integer but it would have decimal places or is too large and
should be declared as Double. For example:
Dim I as Integer
The issue is resolved by changing this line of code to:
Dim I as Double
You can also try Long.
You might also get this error if you are dividing by zero. Check your
calculations to make sure there would not be a case where you are dividing
by zero.
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Amy Vargo
Microsoft Access Engineer
This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. ? 2001 Microsoft Corporation. All rights
reserved.