How to Add an MDF Into an ODBC

Updated July 19, 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.

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Jim Campbell has been a computer engineer for over five years. He excels in hardware repair, computer programming and troubleshooting, and software design. He is currently attending Florida Atlantic University, pursuing a master's degree in computer and electrical engineering and fine-tuning his technical writing abilities.