canuckconsulting
asked on
MS Access Update statement locking on updating SQL Server
We have a MS access form which connects to a SQL Server 2012 table. Occasionally the Access application times out when trying to update a specific field in the table. The odd thing is that while the application freezes we are able to open sql server manager and update the record directly. This indicates the issue is not with a db lock.
Any thoughts on what we can do to dig deeper?
Any thoughts on what we can do to dig deeper?
I am under the impression that you have linked tables from SQL to Access and you perform the Update on these linked tables....if you change your Update statement from a passthrough query it should work fine
Updating a specific record using a form bound to a query of a linked table isn't a problem and does not require a passthrough query.
How do you know what field is being updated when the form freezes? Is there code in the form that is actually causing a loop under some situations? Access doesn't even attempt to save the record until you move focus to a different record or do something else that triggers Access into doing a save.
How do you know what field is being updated when the form freezes? Is there code in the form that is actually causing a loop under some situations? Access doesn't even attempt to save the record until you move focus to a different record or do something else that triggers Access into doing a save.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.