How to suppress table update messages?

[SimonMurphy]

Hello
I have a set of relational tables linked by a key Reference code. I have
specified that the referential integrity be kept.
I have created a set of forms and subforms where this Reference code is the
linking field.
When I update the Reference code in my master record, Access says that the
data has been changed by another user (altough currently it is on a
standalone machine with no other users). It says that if I continue I will
overwrite the other persons changes. I click [Save Record] and for each of
the related tables where the reference code is updated by the cascade, I get
the same warning.
Why is this message neing displayed and is it possible to stop it appearing?

 

[Jeanette Cunningham]

Hi Simon,
If this is an access database with a jet backend or a single all-in-one
database, the second user is usually you. If you have more than 1 form
(including) a
subform) connected to the same data you can get this error.
If you are connected to some other backend like SQL server, the reasons are
more complex.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[SimonMurphy]

Hi Jeanette
The database is developed with Access 2003 out of the box, so I guess it is
a single all in one. How would I tell?
I have a main form with a tab control, on which there are various subforms.
Is this is an error with Access 2003 that I cannot get round or is there
something I can do about it?
Thanks for your help
Simon

Hi Simon,
If this is an access database with a jet backend or a single all-in-one
database, the second user is usually you. If you have more than 1 form
(including) a
subform) connected to the same data you can get this error.
If you are connected to some other backend like SQL server, the reasons are
more complex.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Hello
I have a set of relational tables linked by a key Reference code. I have
specified that the referential integrity be kept.
I have created a set of forms and subforms where this Reference code is
the
linking field.
When I update the Reference code in my master record, Access says that the
data has been changed by another user (altough currently it is on a
standalone machine with no other users). It says that if I continue I will
overwrite the other persons changes. I click [Save Record] and for each of
the related tables where the reference code is updated by the cascade, I
get
the same warning.
Why is this message neing displayed and is it possible to stop it
appearing?

 

[Jeanette Cunningham]

The error appears when you have more than one form open using the same table
at the same time and both forms can be edited.
Either save and close one of the forms before you open the other, or make
one of the forms read only.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Hi Jeanette
The database is developed with Access 2003 out of the box, so I guess it
is
a single all in one. How would I tell?
I have a main form with a tab control, on which there are various
subforms.
Is this is an error with Access 2003 that I cannot get round or is there
something I can do about it?
Thanks for your help
Simon

Hi Simon,
If this is an access database with a jet backend or a single all-in-one
database, the second user is usually you. If you have more than 1 form
(including) a
subform) connected to the same data you can get this error.
If you are connected to some other backend like SQL server, the reasons
are
more complex.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Hello
I have a set of relational tables linked by a key Reference code. I
have
specified that the referential integrity be kept.
I have created a set of forms and subforms where this Reference code is
the
linking field.
When I update the Reference code in my master record, Access says that
the
data has been changed by another user (altough currently it is on a
standalone machine with no other users). It says that if I continue I
will
overwrite the other persons changes. I click [Save Record] and for each
of
the related tables where the reference code is updated by the cascade,
I
get
the same warning.
Why is this message neing displayed and is it possible to stop it
appearing?

 

[SimonMurphy]

Hello Jeanette
Ok, thank you for the information.
I did not think I had forms open accessing the same table but I will look
into it more closely to check that.
I do have a form with a table fields on the Details section and then a Tab
control with lots of tabs which access the same table.
Anyway as you say I must have more than one form open accessing the same
table. Many thanks for the help.
Simon

The error appears when you have more than one form open using the same table
at the same time and both forms can be edited.
Either save and close one of the forms before you open the other, or make
one of the forms read only.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Hi Jeanette
The database is developed with Access 2003 out of the box, so I guess it
is
a single all in one. How would I tell?
I have a main form with a tab control, on which there are various
subforms.
Is this is an error with Access 2003 that I cannot get round or is there
something I can do about it?
Thanks for your help
Simon

Hi Simon,
If this is an access database with a jet backend or a single all-in-one
database, the second user is usually you. If you have more than 1 form
(including) a
subform) connected to the same data you can get this error.
If you are connected to some other backend like SQL server, the reasons
are
more complex.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


Hello
I have a set of relational tables linked by a key Reference code. I
have
specified that the referential integrity be kept.
I have created a set of forms and subforms where this Reference code is
the
linking field.
When I update the Reference code in my master record, Access says that
the
data has been changed by another user (altough currently it is on a
standalone machine with no other users). It says that if I continue I
will
overwrite the other persons changes. I click [Save Record] and for each
of
the related tables where the reference code is updated by the cascade,
I
get
the same warning.
Why is this message neing displayed and is it possible to stop it
appearing?