Oracle Oracle | DB2 DB2

How to setup Microsoft Access database connection

This chapter will show you how you can connect to your own Microsoft Access database through MSAccess connection. If the connection is successful, you can import contacts from your database to the Ozeki Bulk Messenger Software.

Step 1 - Create new database connection

The very first step is to create a new database connection. To do so, you need to click on Create new database connection button.

Create new database connection
Figure 1 - Create new database connection

Step 2- Type of database

With Ozeki Bulk Messenger software solution you can connect to different types of database servers. In the following figure you can see on which button you need to click to install a new Microsoft Access connection.

Figure 2 - Click to MSAccess

If the Microsoft Office (including Access) has not been installed to the pc on which the Ozeki Bulk Messenger runs yet, you need to install the Microsoft Access Runtime program, which provides the connection between the Ozeki Bulk Messenger and the Microsoft Access database.

Step 3 - Database connection details

There are two possible ways for giving the details: you can give the data below the General menu, or you can give the connection string below the Advanced menu. In case you give the connection string, it overwrites the data given below the General menu.
In this example we give the connection string under the General menu:
  • Provider's type: Microsoft.ACE.OLEDB.12.0
  • The file which contains the database: D:\OzekiBulkMessenger.accdb

Figure 3 - Connection settings

If the connection is successful, a green tick will appear under State.
Click to the Open button to go to the details page of this connection

Figure 4 - Click to Open

The event log will show you if you have connected successfully.
Check the data below Event log

Event log
Figure 5 - Event log

Step 4 - Testing the database connection

If you click to the Test button, you can give the database table in which you store your contact lists.
Click to the Execute button to list the phone numbers that are stored in the given database's table.

Figure 6 - Test the database

Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Technology > Databases > Microsoft Access
Legal | Privacy | Terms of use | 1501 | | Login