Error messages while using ACCESS

I am getting this error when connecting to the database:
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

New versions of OZEKI SMS allow you to control the SQL queries used to access the data in your Access database. In these versions, you must modify these queries to make things work. Here is what you should do:

Remove the apostrophe around the word $id. ('$id' should be changed to $id)

Here is what you'll get after modifying the SQL statements:

modifying sql templates in ozeki sms
Figure 1 - The SQL statements you can modify

This form can be accessed from Ozeki SMS after installing the Database Plugin and clicking on the Plugins / Database Configuration menu item)

Before running the SMS Server you need to delete all the unprocessed queries (see the image below) These unprocessed queries are not stored in order to avoid data loss - in case the queries are not getting processed. After deleting the Uprocessed SQL Queries window section will remain blank.

how to remove unprocessed queries
Figure 2 - Unprocessed queries

I am getting this error when connecting to the database:
[Microsoft][ODBC Microsoft Access driver] The table ('ozekismsout') has ben opened by another user and cannot be accessed

Log out of the Access or close the design view.

I am getting this error when connecting to the database:
[Microsoft][ODBC Microsoft Access driver] Too few paramters. Expected: 1.

Most probably the ozekismsout table doesn't contain all the necessary coloumns. Check the name and number of the coloumns.

More information