The database options are always being improved. It is recommended you download the latest version of Kiwi Syslog Daemon from our downloads page.

Below is a step by step guide explaining how to have Kiwi Syslog Daemon log to an Access database.

1. Open Access 97, 2000 or 2002.
2. Use the File | New menu to create a new blank database. It will prompt you for a filename ending in .mdb (MS database).
3. Create the database file in a convenient location. You might want to call the file Syslog.mdb
4. Close Access.
5. Open Kiwi Syslog Daemon
6. Open the Properties setup window (Ctrl-P)
7. Create a "Log to ODBC database" action
8. From the right hand action settings pane, press the "ODBC Control Panel" button.
9. Press the System DSN tab
10. Press the "Add" button
11. From the list, find the "Microsoft Access driver (*.mdb)"
12. Press the "Finish" button
13. In the "Data Source Name" field, enter the name Syslog.
14. Press the "Select" button
15. Locate the database file you created with Access (Syslog.mbd)
16. Press the "OK" button.
17. You should now see the DSN name in the list
18. Press the "OK" button to close the control panel applet.
19. You should now be back at the ODBC action's settings page... press the "Browse" button
20. Find the DSN name you created from the list and click OK
21. You can leave the Database table name as the default of Syslogd
22. Select a suitable database format from the Database field/format dropdown list. The standard "Kiwi Access format ISO yyyy-mm-dd" is a good one to use.
23. Now press the "Create table" button. This will try to connect to the database and create the table called "Syslogd" in the database specified by the DSN string. If that was successful then you now have a table ready to receive the syslog messages.
24. Press the "Test" button a few times to log some test messages. This should show the green tick beside the button if successful.
25. Now press the "Query table" button. This will read the last 5 lines from the database and show you the values as well as the database field format information.
26. You can now press the "OK" button on the properties window to close it and accept the changes.

The next time a message is received, it will be logged to the database. You can then use Access to open and view the file. If the create table button or test button gives an error, it will mean that the program can't contact the database via the ODBC DSN. You will need to check the specified DSN is correct. A system reboot may also help.

You could have created the table manually from Access, but the "Create table" button does it all in one go and the fields are compatible with the logging format specified.

If you still have issues after following the instructions provided, then please use the technical support form to request further assistance.