Microsoft Access 2013
You will see detailed information on this page to show how to send and receive SMS messages with Microsoft Access 2013 database tables. Please follow these steps and screenshots to configure the connection to perfectly read lines from the outgoing message table and paste lines to the incoming message table. The default table names are 'ozekimessagein' and 'ozekimessageout'.
On the previous page you might have read how to connect to the Access 2013 database and set the SQL statements, but on this page you can see it from the aspect of your Microsoft Access database. At the bottom of this page you can see how to send and receive messages with simple examples.
How to connect SMS Gateway
|Provider=Microsoft.ACE.OLEDB.12.0;Data Source=PathToYourDatabase;Persist Security Info=False|
Keep in mind to change the 'Data Source=' parameter to the location of 'ozeki_database.accdb' (Figure 6).
Figure 6 - Paste your database connection string at the Database User's configuration panel
Switch to the 'SQL for sending' and 'SQL for receiving' tabpages and remove the apostrophes (' ') around $id (Figure 7) and remove it from around all other attributes starting with a $ sign.
Figure 7 - Remove apostrophes from all of the UPDATE statements
Now it is ready to use the configuration of the connection.
Testing the configuration
When testing, you should use both tables. The one which was created for incoming messages and the one which was created for outgoing messages. In these examples these tables are called 'ozekimessageout' and 'ozekimessagein'.
To test the configuration, you should INSERT a message record into the outgoing messages table (Figure 8),
which is called 'ozekimessageout' in the current example. These messages can be SELECT-ed (polled) by configuring the Database User here:
'SQL for sending' tabpage and 'Polling' sub-tabpage. Please search these options in the SMS Gateway's browser GUI.
Figure 8 - INSERT a new row into the outgoing message table
The 'status=' parameter of the message record will change from 'Sending' to 'Sent' to 'Delivered'. The sent message will be visible in the Database User's Outbox folder (Figure 9).
Figure 9 - The test message have been sent
If an incoming message log event is displayed in the Database User's event log (Figure 10), the message entry will be INSERT -ed in the incoming message database table. The INSERT statement can be configured in the 'SQL for receiving' tabpage of this Database User's configuration panel. This is the statement which INSERT-s incoming messages.
Figure 10 - Message is received by Ozeki SMS Gateway. Your Database User will INSERT it into a table.
In this example the incoming message table is called 'ozekimessagein'. This is where those SMS messages are INSERT-ed, which are received by the Database User. You should run a SELECT statement on it (Figure 11) to read all of the messages (Figure 12).
Figure 11 - SELECT messages from the incoming message table
All of the incoming messages can be read after running a SELECT query on 'ozekimessagein' (Figure 12).
Figure 12 - The SMS messages received by Ozeki SMS Gateway's Database User