How do I access ODBC connection string?

How do I access ODBC data source?

Click Start, and then click Control Panel. In the Control Panel, double-click Administrative Tools. In the Administrative Tools dialog box, double-click Data Sources (ODBC). The ODBC Data Source Administrator dialog box appears.

How do you find the connection string in access?

Depending on the data source, you can change the display name, data source path, file name, password, or connection string. Select External Data > Linked Table Manager. Tip In the navigation bar, you can hover over the linked table name to see connection string and other information.

How do I connect to ODBC?

1Click Start and select Settings > Control Panel > Administrative Tools.2Double-click Data Sources (ODBC) to open the ODBC Data Source Administrator.3Select the System DSN tab.4Click Add.5Select SQL Server and click Finish.6Complete the DSN Configuration wizard (see example screen shots below)

What is access connection string?

With database password This is the connection string to use when you have an access database protected with a password using the Set Database Password function in Access. Provider=Microsoft.