Microsoft Access Configuration

If you installed Connect Daily on Windows using the MH Software network downloader, then all necessary configuration steps have been completed for you. If you are installing Connect Daily manually, then you need to follow these directions.

Before using Microsoft Access as your data store for the calendar, please remember the following items:

• Generally speaking, if the calendar.mdb file is open by the web server, backup software will not back it up.
• Access may not perform well during high work loads. One client who had 30 users, 36 resources, and around 25 events per day did not get acceptable performance from Access. Tests indicated that SQL Server, or PostgreSQL outperformed Access by a factor of 100 using the same data.

Edit the configuration.properties file, putting in the configuration entries for your database

DBObjectClass=com.MHSoftware.db.support.MSAccessDB
JDBCDriver=sun.jdbc.odbc.JdbcOdbcDriver.
JDBCConnectString=jdbc\:odbc\:Driver\={Microsoft Access Driver \ (*.mdb)};DBQ\=E:\\calendar.mdb;READONLY\=false

JDBCPassword=calendar
JDBCUserID=calendar

Note the escaping of the \ character by using two \\ characters.