I have been deploying several Access 2003 applications using the Package Wizard included with Microsoft Office Access 2003 Developer Extensions. I package them along with Access 2003 runtime so that the users do not require Access installed on their computers to run the applications.
Each of these applications is actually setup to use two Access databases. The first is a Startup app that opens and checks the last modified date stored in a table within the main application db on the server. If the date is newer on the server, it copies this database down to the local machine. This works fine with Access 2003 because both the main application db on the server and the deployed database on the local machine are in the .mdb format.
However, when I deploy an Access 2010 application along with Access 2010 Runtime it creates a database in .accdr format. The main application database on the server is in .accdb format. So I can no longer just copy the database from the server to the local machine.
Can anyone tell me how I can make this deployment method work with Access 2010?