If you have a 64bit version of Microsoft Office 2007 or 2010 installed on your PC and you want to connect a GroupMail Group to an Access Database that uses the .accdb extension then you need to install the 32bit version of the Microsoft Access ODBC drivers as explained in the steps below.

1) Download the 32bit Access ODBC driver from Microsofts website link below. The file name is called AccessDatabaseEngine.exe:

2) To install the driver you have to launch it from the command line using the /passive switch. Open a Windows Command prompt and from the folder that contains the ODBC driver install file, type in:
AccessDatabaseEngine.exe /passive

Install 32bit driver in passive mode


3) Once installation has completed, open the Windows Control Panel and then open “Administrative Tools“. Open “Data Sources (ODBC)“.

Click on the “Add” button and select the “Microsoft Access Driver (*.mdb, *.accdb)” option then click “Finish“.

Choose Microsoft Access .accdb

4) Give your Data Source a name and then click on the “Select” button. Browse to where your .accdb Access database file is stored and select it. Click OK.

Choose Name and Select accdb Access Database file

You have now added a data source for your .accdb Access Database so the next step is to link a GroupMail Group to it.

5) Open GroupMail and create a new Group. Choose the Group type as “External Database” and click OK.

GroupMail Access

6) Create a new Database connection by clicking on the “New” button.

Choose to create a New data connection

7) Give your connection a name, change the “Cursor Type” to Dynamic. Now click on the “Wizard” button.

change "Cursor Type" to Dynamic and give name then click Wizard

8) Choose “Microsoft OLE DB Provider for ODBC Drivers” can click on the “Next” button.

Choose ODBC Driver suitable for Access .accdb files

9) Click on the drop down list for the data source name and choose the one you created. At the botton of that window, click the drop down list there and choose the path to your .accdb Access Database file. You can test the connection by click on the “Test Connection” button.
Click OK.

Choose data source from drop down list and choose Database from catalogue drop down list

10) You will see the “Connection string” field populated so click the “OK” button.

Connection String populated so click OK

11) Click “Next“.

Click Next

12) Choose the table in your database that contains the recipient information you want if you have multiple tables and then click on the “Next” button.

Choose Database Table from drop down list you want to use and click Next

13) Give your new Group a name so you will recognise it when you see it in GroupMail and then click on the “Create” button.

GroupMail Access

14) You now have a new Group in GroupMail connecting to your Microsoft Access (.accdb) file.

GroupMail Access


As always, if you have any questions or need some help along the way, don’t hesitate to contact our Technical Support team

Comments are closed.