To be clear, Access 2007 is installed on the machine and we only use it to make database changes etc. The application is still using the old jet engine.

Also I wish the original developer would have used ADO instead. However, that was not case and I am stuck trying to fix this.