Version Update 1.1

I've been having a problem with my personal copy of AccessUpdater where if, for some reason, Access doesn't close down all the way and MSACCESS.EXE is still running in the background, then the VBA FileCopy command won't make copies of the needed files because they're open. I got around this by switching to the FSO CopyFile command. I've updated the template to v1.1. If you want to integrate the changes into your existing setup, just copy the FSOCopyFile sub in the module to your module, and rename any instances of "FileCopy" to "FSOCopyFile". There should be 6 of them in a default installation.

"What is Access Updater" you ask?

If you are running a Microsoft Access database over your network, and you have it set up correctly between multiple users, that means you have a Back End file with your tables (or SQL Server) along with a Front End database file for each of your users.

It's easy to make changes on the Back End, but distributing updates for the user Front End files can be a nightmare. This is where Access Updater comes in. 

It's very difficult to distribute changes to multiple Front End databases when you make changes. Access cannot update itself. Furthermore, even if you map to each user's shared network drive (which is a lot of work) they have to exit the database for you to update the file, and if they shut their machine off for the night, you're out of luck. 

Find out more here: Access Updater