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.
- Skill level:
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for