Greetings again from Belgium.
Lately, for an unknown reason (maybe, I am doomed!), I have been facing miscellaneous little, but bothering, problems in some of the applications I designed in MS Access 97. Here, comes another problem that I do not really know how to solve as it happens "by itself".
I have an application that was running on a machine to which were connected (through a LAN) different other machines. Everything went fine for months. Lately, about two or three weeks ago, the application has been transferred onto another machine and, of course, the shorcuts have been modified accordingly. Ever since then, little glitches occurred and here is the most occurring one.
Two ladies are entering data into the application; therefore, when they have no data to enter, they keep the application opened but minimized on their task bar.
About once or twice per day, they see the icon flashing on the task bar and, when they click on the flashing icon, the follow error message appears:
"Run-Time error '3008'
The table '\\chievres-lra\helpdesk management.mdb' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically."
That error message is followed by another message:
"Disk or Network error!
The Microsoft Jet Database Engine cannot find the input table or query 'MSysModulus2'. Make sure it exists and that its name is spelled correctly.
The save operation failed."
Right after that display, a last message appears:
"Out of memory!"
Before I make any comment to those error messages, I would like to precise a couple things:
1) there is no security system attached to the application.
2) only five users are authorized to used the application through the Groups feature of the Windows NT environment.
3) the application used by the ladies is a Replica version, the Design Master version being on my machine.
Now, here are my comments:
1) how can the database be "opened exclusively" as nowhere have I been setting anything to do that? The way I set all my applications is "record opened exclusively" and not database.
2)"...and cannot be manipulated programmatically": no one of the users has the knowledge to manipulate programmatically and, considering the Replica status of the application, no new coding and no coding edition is enabled.
I do not understand why that error occurs and, consequently, I do not know how to solve it.
Please, help me.