I notice from this forum that ActiveSMS uses and ODBC connection to an Access database. Can this be changed so the ODBC uses an SQL server?

We're looking at putting it in for relativley light usage but don't really want to have to manage an Access file when there are plenty of SQL resources around.

Yes, ActiveSMS is designed to also work with Microsoft SQL service.

Here are the instructions lifted out of the ActiveSMS User Manual:

You can also configure ActiveSMS to log to a Microsoft SQL Server or MySQL database if you prefer by performing the following steps:
- Create a new SQL Server or MySQL database
- Create a new System DSN and set the default database.
- In the SMS Queueing settings enter the DSN and Username/Password (if required)
- Click Test Connection
- Click Create Tables