Updating linked database c
From the menu bar, select inked Tables as shown below: By default, Microsoft Access will want to link to another Access database for it's Linked Table source.
Browsing the 'Files of Type' pull-down menu on the bottom left of the interface will give you a general idea of just how broad of a scope is available for Linked Table sources.
When creating the DSN for this process, you configured it to use either SQL Server or Windows (Trusted) security.
You will be prompted again at this point when attempting to make use of the DSN.
The new home for Visual Studio documentation is Visual Studio 2017 Documentation on docs.
The latest version of this topic can be found at Recordset: Adding, Updating, and Deleting Records (ODBC). For more information about how updates are carried out and how your updates appear to other users, see Recordset: How Recordsets Update Records (ODBC).
In a nutshell, you are being asked for the primary key for the table.
Since we are focusing on SQL Server as a data source, navigate down the list of 'Files of Type' options and select the 'ODBC Databases()' option.
Then click the 'Lin Once you have either created or identified the proper SQL Server DSN, highlight it and click the 'OK' button.
We are going to focus strictly on linking to SQL Server tables for this exercise.
I am using Northwind as a database source in this tip, so you will see below that I have selected all tables except for the date-specific table 'Category Sales for 1997' in the tables listing on the interface.