Replace Changes Error

[Julie]

I have created a database for several users to be in the
same form at the same time. However, each user filters the
form to show their records only. Updates are normally made
to their individual records as well.

However, when closing out of the database, they get an
error that states "the database has changed since the last
time you opened it, either by another user...Do you want
to replace the changes that you or another user made? To
save your most recent changes and discard the other user's
changes...click Yes."

Because the data they type saves immediately, the users
data is never deleted and they always click yes to this.
However, it worries new users and I'd rather not have the
error pop up.

I have tried using a Close macro that saves all data
without prompting, and also a Quit macro that does the
same, but the error keeps happening.

Any suggestions?? Thanks for any help.

 

[Rick Brandt]

I have created a database for several users to be in the
same form at the same time. However, each user filters the
form to show their records only. Updates are normally made
to their individual records as well.

However, when closing out of the database, they get an
error that states "the database has changed since the last
time you opened it, either by another user...Do you want
to replace the changes that you or another user made? To
save your most recent changes and discard the other user's
changes...click Yes."

Because the data they type saves immediately, the users
data is never deleted and they always click yes to this.
However, it worries new users and I'd rather not have the
error pop up.

I have tried using a Close macro that saves all data
without prompting, and also a Quit macro that does the
same, but the error keeps happening.

I believe that the "changes" referred to in that message are changes to the form
itself such as filters applied, etc., not the data. The reason this is happening is
because you have multiple people using the same file. The recommended approach for
multiple users is to have a spilt application where all of the tables go on a shared
network file and each user has their own separate copy of a front end file linked to
the data file that is stored on local disk. That way each person has their own form
and these changes do not affect anyone else. This method also performs better and
suffers fewer corruption problems.