title: Update Query Timeout on SQL Server View with MS Access
body: <p>I am having some trouble with updates to an SQL Server View through MS Access. The set of tables used for this is built off of a base table. This base table is of this format.</p>
  
  <pre><code>Id    int (not-nullable; auto-assigned)
  A1    varchar(50) (nullable)
  A2    varchar(50) (nullable)
  B1    varchar(50) (nullable)
  B2    varchar(50) (nullable)
  C1    varchar(50) (nullable)
  C2    varchar(50) (nullable)
  </code></pre>
  
  <p>One row on this table is updated by multiple groups of users in our company. For instance, user group "A" updates columns "A1" and "A2", user group "B" updates columns "B1" and "B2", and so forth. However, we also want to prevent user group "A" from updating the columns of user group "B". To accomplish this, I set up a view containing the columns appropriate for each user group. For instance, the view for user group "A" would only contain the columns "Id", "A1", and "A2". Then I set the "Bind To Schema" option on the views in SSMS to "Yes", and I set up a unique, clustered index on the "Id" column on each of the views. In MS Access, I connect to these views as linked tables using an ODBC connection. When I open the tables in MS Access in design view and check the indexes, it does properly identify the "Id" column as the primary key.</p>
  
  <p>Here is where the trouble comes in: When I try to update a record through MS Access in one of the views, sometimes the update runs instantly, but sometimes the update times out. Here is the error that I get.</p>
  
  <p><a href="https://i.stack.imgur.com/ajAee.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ajAee.png" alt="Timeout Error Message"></a></p>
  
  <p>"SM_Notes_Bridge" is the actual name of one of my views. Almost all previous answers that I can find online say to increase the amount of time before the update times out in MS Access, which seems like it is not a solution for my problem as the update either runs instantly or times out. There is no middle ground.</p>
  
  <p>Another note is that I am currently the only one using this base table and these views. Also, important systems are developed around that base table structure, so changing its structure will take a lot of convincing.</p>