How to update a local Access front end via a shell command within Access
Posted on 2014-12-01
I setting up a front end deployement system that will execute when a user opens up his or her local copy of a front-end so that the most recent copy on the network drive will overwrite an existing older version on the user's drive. I'm thinking it should be on the load event of the main form. I now have a local table on the front-ends, named LocalVersion that has the version number of the current version. On the network drive, I have an mde file that contains only a single table with a single row, This row has the version number of the latest version of the front-end. Each front-end is linked to this table, when the user starts up their copy of the front-end, an autoexec macro is executed that checks to see that the front-end is linked to the backend. After this, I will compare the version number on the local version table to the version number in the RemoteVersion table via a dlookup function within an if statement. If it is less than the remote version number, I want to overwrite the existing local user front-end via a shell batch command from within access. Do I first have to close the existing local user front end before overwriting the local access front-end? If so, if the how will the rest of the batch file execute. I'm not all that familiar with executing a batch file within a shell command on application start up. I think I've got most of the pieces in place for this to work (other than making sure everyone is using the same mapping structure). Thanks.