How do I set up ODBC in access?

Question

Add an 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). . Click User DSN, System DSN, or File DSN, depending on the type of data source you want to add. . Click Add.

Where is the ODBC connection in Access?

From your Windows desktop, click Start Settings Control Panel and open the Administrative Tools control panel. In the Administrative Tools window, double-click Data Sources (ODBC). In the ODBC Data Source Administrator dialog box, click Add.

How do I enable ODBC?

Enabling ODBC debug logging (Windows)1Open the ODBC Data Source Administrator window by clicking Start > Settings > Administrative Tools > Data Sources (ODBC).2In the ODBC Data Source Administrator window, click the System DSN tab.3Select the NZSQL system data source and click Configure.4Click the Driver Options tab.

How do I create a connection to an Access database?

Here is how to create a connection to a MS Access Database:1Open the ODBC icon in your Control Panel.2Choose the System DSN tab.3Click on Add in the System DSN tab.4Select the Microsoft Access Driver. ... 5In the next screen, click Select to locate the database.6Give the database a Data Source Name (DSN).7Click OK.

Expert · Answer