How to programmatically create an ODBC Linked Table to a SQL Server View and have it be editable?
It’s not because it’s DSN-less, but because you created it via VBA. If you link the view via the Access GUI, it asks you for the primary key. But via VBA, it doesn’t know the primary key, so the linked view is not updateable. With a table, Access gets the primary key automatically via ODBC, … Read more