Hello, I'll thank anyone who helps up front!!!
I have a large db that we have been using for 18months or so. It contains several tables with related table (form+subform). This db is shared on a network with 6-8 users. I store much data and also images in it.
It has been working flawlessly for a long time but in the last four days the users and me (admin) are getting a funny error. At one point or another, when entering data on a subform, we get an "Invalid Argument" error when picking a value off a combo box (which obviously has a limited number of correct choices). Once one user gets the error message, all others get the same error when trying to enter data using the same combo box. Data in other tables seem to be getting updated quite inconsistently. It does not matter if the 2nd user was logged in at the time the first error showed up or not. Shutting down Access on all machines and restarting it does not fix the problem. Only running the "Compact and Repair" feature fixes the problem. However, a day later, the problem shows up again.
Any suggestions?
Thanks again
Rcmob
I have a large db that we have been using for 18months or so. It contains several tables with related table (form+subform). This db is shared on a network with 6-8 users. I store much data and also images in it.
It has been working flawlessly for a long time but in the last four days the users and me (admin) are getting a funny error. At one point or another, when entering data on a subform, we get an "Invalid Argument" error when picking a value off a combo box (which obviously has a limited number of correct choices). Once one user gets the error message, all others get the same error when trying to enter data using the same combo box. Data in other tables seem to be getting updated quite inconsistently. It does not matter if the 2nd user was logged in at the time the first error showed up or not. Shutting down Access on all machines and restarting it does not fix the problem. Only running the "Compact and Repair" feature fixes the problem. However, a day later, the problem shows up again.
Any suggestions?
Thanks again
Rcmob