Method for updating tables that users are looking at?

Method for updating tables that users are looking at?

Method for updating tables that users are looking at?

I’m looking for a method to allow for a table to be updated that others are running select queries on?

We have an MS SQL Database storing tables which are linked through ODBC to an Access Database front-end. We’re trying to have a query run an update on one of these linked tables but often it is interrupted by users running select statements on the table to look at data though forms inside access.

Is there a way to maybe create a copy of this database table for the users to look at so that the the table can still be updated?

I was thinking maybe a transaction but can you perform transactions for select statements? Do they work that way?

The error we get inside access when we run the query while someone has the table open says:

https://preview.redd.it/tohnzcn588j61.png?width=425&format=png&auto=webp&s=31f2d989c3ec513e3f20a136e6c5e5dce396603f

Any help is much appreciated,

Cheers

submitted by /u/ChufferMcDonld
[link] [comments]


Go to Source of this post
Author Of this post: /u/ChufferMcDonld
Title Of post: Method for updating tables that users are looking at?
Author Link: {authorlink}