R
RL
Good afternoon.
We are getting a Write Conflict error message when closing a form which
links to a SQL table. That SQL table contains a BIT field which I understand
to be the SQL equivalent of an Access yes/no field.
Have you any idea what may cause this problem (please see below for more
detail on the application)?
MORE DETAILS:
We have a Microsoft Access 2007 tool. The main screen of this tool is a form
[Customers] containing one record per customer. That form contains various
tabs each containing a subform. One of these is a Standing Order tab.
A SQL Server 2005 table [Standing Order Details] contains all the underlying
standing order details . Each record represents one installment of a product.
This data is entered, viewed and edited via the standing order tab in the
Access 2007 tool.
Upon opening the tool, a make table query creates a table [Standing Order
Summary] which feeds the standing order tab. That query is grouped on
Standing Order reference and installment date.
Cicking on any record within that tab, opens another form [Standing Order
Details] in dialogue mode, filtered by the corresponding SO reference and
instalment date. The recordsource for that form is the linked SQL table
[Standing Order Details].
We wished to keep a log of who and when amendments were made to this data,
so in order to amend the standing order, a user must click on that record's
'Change' button.
The change button opens another form which uses a second SQL table (Standing
Order Amendments) as the record source. The window is again dialogue mode and
the data in 'Add' mode. Hidden fields are populated with the date, Windows
username, and Standing Order Details using default values.
Visible fields are populated with the Standing Order Details also using
default values. The user changes these visible fields and then closes that
form. So each record contains the time, date and user that made the change as
well as the values before and after the change.
When that form is closed, a setvalue macro copies the standing order
amendments to the standing order details form and then closes the standning
order amendments form.
When we then try to close the [Standing Order Details] form, a 'Write
Confict' error message appears saying 'This record has been changed by
another user since you started editing it...'
This did work for a while, so am not sure why it would have changed. Any
ideas?
We are getting a Write Conflict error message when closing a form which
links to a SQL table. That SQL table contains a BIT field which I understand
to be the SQL equivalent of an Access yes/no field.
Have you any idea what may cause this problem (please see below for more
detail on the application)?
MORE DETAILS:
We have a Microsoft Access 2007 tool. The main screen of this tool is a form
[Customers] containing one record per customer. That form contains various
tabs each containing a subform. One of these is a Standing Order tab.
A SQL Server 2005 table [Standing Order Details] contains all the underlying
standing order details . Each record represents one installment of a product.
This data is entered, viewed and edited via the standing order tab in the
Access 2007 tool.
Upon opening the tool, a make table query creates a table [Standing Order
Summary] which feeds the standing order tab. That query is grouped on
Standing Order reference and installment date.
Cicking on any record within that tab, opens another form [Standing Order
Details] in dialogue mode, filtered by the corresponding SO reference and
instalment date. The recordsource for that form is the linked SQL table
[Standing Order Details].
We wished to keep a log of who and when amendments were made to this data,
so in order to amend the standing order, a user must click on that record's
'Change' button.
The change button opens another form which uses a second SQL table (Standing
Order Amendments) as the record source. The window is again dialogue mode and
the data in 'Add' mode. Hidden fields are populated with the date, Windows
username, and Standing Order Details using default values.
Visible fields are populated with the Standing Order Details also using
default values. The user changes these visible fields and then closes that
form. So each record contains the time, date and user that made the change as
well as the values before and after the change.
When that form is closed, a setvalue macro copies the standing order
amendments to the standing order details form and then closes the standning
order amendments form.
When we then try to close the [Standing Order Details] form, a 'Write
Confict' error message appears saying 'This record has been changed by
another user since you started editing it...'
This did work for a while, so am not sure why it would have changed. Any
ideas?