To setup the ActiveSMS Client you need to setup a System DSN to point to the .mdb file on the server. The procedure as follows:
1) On the Server, create a File Share for the directory C:\Program Files\IntelliSoftware\Database.
2) On the Client, install ActiveSMS selecting the 'Client Only Components' option.
3) On the Client, map a network drive to the File Share created above (e.g. 'I:').
4) On the Client,
- open Data Source ODBC,
- Add new System DSN,
- Driver: Microsoft Access Driver,
- Data Source Name: 'IntelliSMS'
- Select the ActiveSMS database file, (e.g. 'I:\ActiveSMS.mdb')
5) To test setup, on the client, open the ActiveSMS Console and click the Test Connection button.
The configuration above using a Microsoft Access database file access via a network share. An alternative approach would be to use Microsoft SQL or MySQL database, and have the DSN on the server and client point to the same database.