I have a Microsoft Access database that is stored on a network. Everyone has a shortcut on their desktop that they click to use. I also have a .bat link on their desktops too, which when they run the .bat, it updates the database to the new version to include the changes or new features I have added. However if they don't run the .bat they are still able to click the shortcut to the database and in effect be still operating the old version. I thought about creating a macro in the autoexec macro that runs on startup to automatically run the .bat to do the updates, but this obviously won't work b/c it would be trying to update a program that is already open. I would think I would be able to make a new access program that when you click it, it would automatically run the 1) .bat for my other database 2)Close the MS Access database that opened to run the .bat 3) Open the database that the .bat updated // I hope this makes sense as to what I am trying to do