ACCESS write conflict solution ???

H

hpesata

Hi!

I am using an ACCESS 2003 .ADP as a frontend for a MS SQL Server 2005
Express Edition
database.

I have a form, which has 4 subforms which all have the same table as
data-source,
the subforms are part of a tab-control.

I encountered the problem, that after modifying a field in one subform
and changing
to another, an ACCESS-message-box appears which tells me that another
user has
modified the data and I can just save/ignore/save to clipboard.

I use a timestamp column within my table and also dont have an BIT
fields
with possible NULL values.

how can I get rid of these ACCESS-message-box ?

any help with this is greatly appreciated,
thanx in advance!

regards,
Hans
 
M

Maurice

Sometimes it can be that the first form is still "Dirty" when going to the
subform. As a solution you could try setting dirty to false before entering
the subform. This might just solve the messagebox with the several options.

Maurice
 
H

hpesata

Hi!
Sometimes it can be that the first form is still "Dirty" when going to the
subform. As a solution you could try setting dirty to false before entering
the subform. This might just solve the messagebox with the several options.
Click to expand...

thanx for Your reply!

thsi didnt do the trick either but I managed to use the tab-control
without underlying
forms and now all my controls are on just one form and therefore can
access my table with no problems!

regards,
Hans
 
Top