DroidDB Tip of the Month
DroidDB® Tip for April 2020
Setting Up a 32-bit ODBC Data Source on a 64-bit Machine
In 64-bit Windows, there are two ODBC Data Source Administrators: a 32-bit version and a 64-bit version. DroidDB is a 32-bit product. Consequently, ODBC Data Sources for use with DroidDB need to be created with the 32-bit ODBC Data Source Adminstrator.
To set up a 32-bit ODBC Data Source to access an MS Access database, do this:
- Run C:\WINDOWS\SysWOW64\odbcad32.exe
- Click on the "System DSN" tab
- Click the ADD button
- Select the "Microsoft Access Driver (*.mdb, *.accdb)" and click FINISH
- Set "Data Source Name" to "MS Access Database 32". Leave all the other settings alone
- Click OK
DroidDB on the desktop will now include "MS Access Database 32" as a possible "Desktop Data Source".