DBinPhilly
05-24-2013, 05:12 PM
Circumstance: A database shared by 2 workstations. the Back End is on a shared Network drive, the front ends reside on each workstation.
I'm told that when a user is entering data on one workstation and someone signs into the program on the other workstation, bad things happen.
Tonight there was a database corruption. A memo field was left with #ERROR in it which required a compact and repair of the back end.
The following message was displayed when attempting to access the memo field within the affected table:
The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at the same time.
As far as I know, that is not what is happening. Each user is entering his own record into the tables. It is a somewhat complex form, with 3 or more subforms referring to related tables, but the main table is the one that is being corrupted.
This has happened twice in the last week.
Any ideas on how to prevent this problem?
The user is running MS Access 2007 on a Windows XP machine. I believe the second user is Windows 7 and MS Access 2010.
I'm told that when a user is entering data on one workstation and someone signs into the program on the other workstation, bad things happen.
Tonight there was a database corruption. A memo field was left with #ERROR in it which required a compact and repair of the back end.
The following message was displayed when attempting to access the memo field within the affected table:
The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at the same time.
As far as I know, that is not what is happening. Each user is entering his own record into the tables. It is a somewhat complex form, with 3 or more subforms referring to related tables, but the main table is the one that is being corrupted.
This has happened twice in the last week.
Any ideas on how to prevent this problem?
The user is running MS Access 2007 on a Windows XP machine. I believe the second user is Windows 7 and MS Access 2010.