How to Add an MDF Into an ODBC

Written by jim campbell | 13/05/2017

An MDB extension indicates that the file contains an Access database. You create an ODBC connection that contains the MDB file, so applications can use the connection properties to retrieve data from your Access tables. Windows has an ODBC administrator utility that lets you set up ODBC connections to any database file, including Microsoft Access. The connection allows you to write programs that can use the connection without creating a connection for each application.

Click the Windows "Start"' button and select "Control Panel" from the menu options. Click the "System and Security" link in the new window. Click "Administrative Tools," then double-click "Data Sources (ODBC)." The ODBC utility opens.

Click the "Add" button to open a wizard that helps you create the ODBC connection. Select a connection type. Since you are adding an Access connection, select "Microsoft Access" and click "Next."

Click the MDB file you want to use in the connection. If the Access file requires a user name and password, type it into the window and click "Next." Click "Next" until you reach the final window. The defaults to open the Access file are applied. Click "Finish" to create the connection and save it to your computer.

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.