“…How do I create a Database Connection in GroupMail to an MS Access Database?..”

Using the GroupMail Business Edition, go to the Tools Menu, Database Connection Manager.

GroupMail Database Connection

Database Connection in GroupMail

Click on the New Button to create a new Database Connection. For this example we will connect to a Microsoft Access Database called Customers. The Database can be stored locally on your PC or a shared Network drive perhaps.

Database Connection in GroupMail

Specify a Name for the Database Connection and then click on the Wizard Button to create the Connection.

Database Connection in GroupMail

The table below lists some of the more commonly used databases together with the driver that should be selected.
Database NameRecommended Provider
Microsoft® Access®Microsoft Jet 4.0 OLE DB Provider
Microsoft® FoxPro®Microsoft OLE DB Provider for ODBC Drivers
Microsoft® SQL Server®Microsoft OLE DB Provider for SQL Server
MySQL®Microsoft OLE DB Provider for ODBC Drivers
Oracle®Microsoft OLE DB Provider for Oracle
Clipper / DBaseMicrosoft OLE DB Provider for ODBC Drivers

 

If the required provider is not displayed in the list you may need to download and install either an OLE DB Provider for your database or if one is not available then an ODBC Driver. These downloads should be available from your database producers website.

Select the Microsoft Jet 4.0 OLE DB Provider and press Next.

Database Connection in GroupMail

On the Connection Tab, you can browse to your Database File by clicking on the Browsebutton.  Now please click on the ‘Test Connection’ button to ensure it works. If the connection is successful the following message is returned.

Database Connection in GroupMail

Choose OK on the Microsoft Data Link screen, and OK on the Data Link Properties screen to return to the Create a New Database Connection.

Database Connection in GroupMail

The connection string to your database is now specified. There are a number of other options available, the two important ones are Cursor Type and Lock Type. For most configurations set Cursor Type = Static and Lock Type = Optimistic. If this does not work then try ticking the Client Cursor option.

Cursor Type

Forward Only – This is the default setting, this option is supported by most databases, however is not recommended for use with GroupMail as while it can be used to display the data returned from the database, attempting to perform searches and/or modifying the data will result in errors. Static – (Recommended) This cursor type offers the best performance when communicating with the database so if the database supports it this should be used.
KeySet – Should only be used if Static option is not supported by the database.
Dynamic – Should only be used if Static option is not supported by the database.

Lock Type

Optimistic – (Recommended) Use this setting if you want to give GroupMail users the ability to modify the underlying data in the database. Note that using this setting does not guarantee updating capability as it may not be possible due to the way the group is defined, underlying security privileges or that it is simply not possible using the current data source.
Read-Only – This setting is useful when you do not wish the GroupMail user to update the underlying data in the database.
Batch Optimistic – Behaves in the same manner as the optimistic setting, if the underlying database supports this option.
Pessimistic – No noticeable difference when using GroupMail than using the optimistic setting if the underlying database supports it.

It is recommended that the other settings are left at their default values i.e.
Client Cursor – Off
Asynchronous – Off
Command Type – Text

Choose OK to complete.

Thats it!

The database connection to your MS Access database is configured!

You are now ready to create an External Group and link GroupMail to your MS Access Database.

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.