maybe I should have made myself clearer, the web application is not actually deployed to a server on the internet, just accessed from a local network connection by a few users.

access was not my choice of database as the system was created previous to me becoming an employee.

the reason for rolling our own calendar is because this is part of a system that we sell to clients and thus everything it uses has to be license free.