title: How to programmatically create an ODBC Linked Table to a SQL Server View and have it be editable?
body: <p>When I create a DSN connection to SQL Server using the wizard, I am able to link it to a view. In this case, Access recognizes it as an editable table.</p>
  
  <p>But if I use a DSN-less connection to a view using vba code (Method 1 from <a href="https://support.microsoft.com/en-us/kb/892490" rel="noreferrer">https://support.microsoft.com/en-us/kb/892490</a>), it is linked as a table that is NOT updatable.</p>
  
  <p>I don't know why there is a difference, but how can I make a connection to a view in SQL Server (either as a table or a query in Access) and have it be updatable?</p>
  
  <p>Edit: When I make a DSN-less connection using a table in SQL Server rather than a view, it is updatable in Access. I would have guessed my problem has to do with views not having a unique ID, but I'm confused why a DSN connection can be updatable while DSN-less cannot.</p>