D
Dawn
I have a problem when linking tables from SQL server into
Access.
I have a complex form which is based on a query based on
the linked SQL table.
Many Users access this form read and then possibly update
the information. Also, in the events of drop down boxes
on the form, when information is changed, I have code
which tries to update a number of records in the same
table depending on what it is changed to.
The problem I seem to be having is that SQL locking
architechture is locking the table so that when someone
updates the record, and my event is triggered running an
update on other records in the table, it timesout because
it can't get the locks it requires.
How can I amend my database to allow the data to be read,
and updated (both on screen and by procedure behind the
scenes), whilst still allowing others to read and update.
Any help on this would be very much appreciated.
Access.
I have a complex form which is based on a query based on
the linked SQL table.
Many Users access this form read and then possibly update
the information. Also, in the events of drop down boxes
on the form, when information is changed, I have code
which tries to update a number of records in the same
table depending on what it is changed to.
The problem I seem to be having is that SQL locking
architechture is locking the table so that when someone
updates the record, and my event is triggered running an
update on other records in the table, it timesout because
it can't get the locks it requires.
How can I amend my database to allow the data to be read,
and updated (both on screen and by procedure behind the
scenes), whilst still allowing others to read and update.
Any help on this would be very much appreciated.