G
Guest
I am having a rather strange problem with a database at work, and I was
hoping to get other diagnosis beside my own.
The database is in Access 97. Multiple users use the database
simultaneously. We could not use the Workgroups or any built in multi-user
systems, so we built our own using a table in the back end. The system has 5
user levels of security. Fairly straightforward, select your name from a
list, the form confirms you entered the right password, gets your 'user
level' and opens to the applicable screen.
Level 1 goes to their own Tabbed Screen, with 4 subscreens. Subscreen #4
is the same form set the other users access, but nested as a subform.
A few weeks ago, after several months of smooth operations, we started
getting an error when the level 3 users tried to exit. This error is not
happening every day, and there appears to be no apparent pattern. The
message reads as follows:
"[FormName] has been changed since the last time you opened it, either by
another user or because another instance of it was opened on your own
machine."
Plus the standard save as new name, old name choices
I am trying to figure out
1.) What is causing this problem?
2.) How to correct it.
I have a few specific questions
1. The form uses queries for the datasource. Would changing the
datasource with a commandbutton (i.e Form.Datasource = "Qry_01") be what is
causing this?
2. Is it possible that the Docmd.Maximize/Minimize commands are somehow
causing this?
3. Could it be the Special Access keys causing it?
4. Would this problem disappear if the users had the Runtime version of
Access instead of the full version?
Your thoughts would be greatly appreciated.
hoping to get other diagnosis beside my own.
The database is in Access 97. Multiple users use the database
simultaneously. We could not use the Workgroups or any built in multi-user
systems, so we built our own using a table in the back end. The system has 5
user levels of security. Fairly straightforward, select your name from a
list, the form confirms you entered the right password, gets your 'user
level' and opens to the applicable screen.
Level 1 goes to their own Tabbed Screen, with 4 subscreens. Subscreen #4
is the same form set the other users access, but nested as a subform.
A few weeks ago, after several months of smooth operations, we started
getting an error when the level 3 users tried to exit. This error is not
happening every day, and there appears to be no apparent pattern. The
message reads as follows:
"[FormName] has been changed since the last time you opened it, either by
another user or because another instance of it was opened on your own
machine."
Plus the standard save as new name, old name choices
I am trying to figure out
1.) What is causing this problem?
2.) How to correct it.
I have a few specific questions
1. The form uses queries for the datasource. Would changing the
datasource with a commandbutton (i.e Form.Datasource = "Qry_01") be what is
causing this?
2. Is it possible that the Docmd.Maximize/Minimize commands are somehow
causing this?
3. Could it be the Special Access keys causing it?
4. Would this problem disappear if the users had the Runtime version of
Access instead of the full version?
Your thoughts would be greatly appreciated.