Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / December 2004

Tip: Looking for answers? Try searching our database.

Overflow Error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Joe - 14 Dec 2004 05:46 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.