This section describes how to set up the ipushpull DB Loader to use an MS Access database. It also includes a troubleshooting section with solutions to common problems.
- Start the DBLoader and click Configure Database Connection.
- Select MS Access from the dropdown menu.
- Enter the full path to the database in the Database Path field. You can find this by starting Access, opening your database, selecting the File menu, clicking View and edit database properties, then clicking the General tab:
In the example above the full path to the database is C:\Users\iPP2\Documents\Database2.accdb
- If the database is password protected, enter it in the Password field. Leave this field blank if it's not password protected.
When it's finished, the settings box should look something like this:
Press Test Connection to check that it's working. If all is well, you should see the following message:
'Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine'
This error message may be displayed when you test an MS Access connection or try to connect for the first time.
It means that a piece of Microsoft software that is required to connect the DBLoader to your database is not installed on your machine.
To solve the problem, download the version of the software suitable for your version of Access from Microsoft and install it.
Once installed, restart the DBLoader and try again.