MS Access front end SQL 2019 Express backend. We have a linked view. Several columns from one table with about 16k records. The view is bound to a read only tabular form. All is well until a user sorts the view. When the view is sorted it places a table lock on the table and other users are locked out of the table for updates. Any ideas where to check? Thanks in advance.
Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>