M
Mick N., Sr.
Hope somebody can give a clue to the following error we are now
getting:
"The Microsoft Jet database engine stopped the process because
you and another user are attempting to change the same data at
the same time."
Some history first....
Have recently upgraded an MS-Access 97 database to the 2000 version.
The original database was a single MDB (converted from MS-Access 95)
and contained several large tables of redundant data, and no Modules
(everything done with Macros). None of the tables had Relationships,
even though they did have similar fields (maintained very badly with
the macros).
The new database is now broken down into a backend data portion, which
has the original tables divided up into sub-tables, joined with
Relationships (full integrity) to two main tables. And the frontend
logic database portion, which has the converted Macros, now replaced
with VBA coding (either in Forms and Reports, or as separate
modules). And most Forms are bound to one of the two main tables,
with several sub-forms within them linked by their common ID field.
The environment is a network of a dozen PCs all running Windows-2000,
including the File Server which holds the backend database. The
frontend links to the backend data tables, and a copy of it resides on
each of the desktops.
All of this is working pretty good, except for one single Form. It
has six sub-forms which are the sub-tables related to the main table
that the main form is bound to. The problem arises when entering a
new main record and tabbing to the sub-forms to complete the whole
connected set of information. Sometimes this works quite well and
several new records may be entered one right after the other. Other
times the 3197 ERROR occurs when someone tries to tab to one of the
sub-forms. There does not seem to be any pattern as to which
sub-form, or how often it occurs, or on which desktop or user.
Have made sure the data is clean and that no records are screwed up.
Have run JETCOMP to see if that found anything. Have even exported
and imported the data into a new database.
All of the forms and sub-forms have the same Properties:
Recordset Type: Dynaset (Inconsistent Updates)
Record Locks: No Locks
The database Options (under Advanced) are set to:
Default Open Mode: Shared
Default Record Locking: No Locks
"Open databases using record-level locking" is checked.
If anybody has an answer to why this error is occurring, and what may
resolve it, I would be most greatful to learn from your experience and
knowledge.
Thank you for any help.
getting:
"The Microsoft Jet database engine stopped the process because
you and another user are attempting to change the same data at
the same time."
Some history first....
Have recently upgraded an MS-Access 97 database to the 2000 version.
The original database was a single MDB (converted from MS-Access 95)
and contained several large tables of redundant data, and no Modules
(everything done with Macros). None of the tables had Relationships,
even though they did have similar fields (maintained very badly with
the macros).
The new database is now broken down into a backend data portion, which
has the original tables divided up into sub-tables, joined with
Relationships (full integrity) to two main tables. And the frontend
logic database portion, which has the converted Macros, now replaced
with VBA coding (either in Forms and Reports, or as separate
modules). And most Forms are bound to one of the two main tables,
with several sub-forms within them linked by their common ID field.
The environment is a network of a dozen PCs all running Windows-2000,
including the File Server which holds the backend database. The
frontend links to the backend data tables, and a copy of it resides on
each of the desktops.
All of this is working pretty good, except for one single Form. It
has six sub-forms which are the sub-tables related to the main table
that the main form is bound to. The problem arises when entering a
new main record and tabbing to the sub-forms to complete the whole
connected set of information. Sometimes this works quite well and
several new records may be entered one right after the other. Other
times the 3197 ERROR occurs when someone tries to tab to one of the
sub-forms. There does not seem to be any pattern as to which
sub-form, or how often it occurs, or on which desktop or user.
Have made sure the data is clean and that no records are screwed up.
Have run JETCOMP to see if that found anything. Have even exported
and imported the data into a new database.
All of the forms and sub-forms have the same Properties:
Recordset Type: Dynaset (Inconsistent Updates)
Record Locks: No Locks
The database Options (under Advanced) are set to:
Default Open Mode: Shared
Default Record Locking: No Locks
"Open databases using record-level locking" is checked.
If anybody has an answer to why this error is occurring, and what may
resolve it, I would be most greatful to learn from your experience and
knowledge.
Thank you for any help.