Page History
...
- Within Windows, go to Start > Control Panel > Administrative Tools > Data Sources (ODBC) and right-click on Data Sources to Run as Administrator
- Click the System DSN tab if you want any other user of that computer to be able to access the ODBC data source.
Click the User DSN tab if you want only your username on that computer to be able to access the ODBC data source. - Click the Add button within the DSN tab.
- Within the list of available drivers, choose "Microsoft Access Driver (*.mdb, *.accdb)" and click Finish
- Within the ODBC Microsoft Access Setup dialog, enter a Data Source Name, enter a description and click the Select Database... button
- Browse to the Access database file you wish to use and click OK
- Within the DSN tab, you should now see the Data Source Name you entered above in step 5. Click OK
- Now, within Aqua Data Studio, continue with the server registration process
...
For Microsoft Access, the entire database is stored as a single file on a host machine either as a .mdb file or .accdb file.
| Generic ODBC Properties MS Access | Microsoft Access Schema | Query in Microsoft Access |
...
| Code Block |
|---|
select * from "C:\ms_access_files\DBSAMPLE".[Airplane - Seat Locations] GO |
Microsoft's ODBC Driver
...