Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Home > Courses > Access > Templates > Access Updater 1 >
Access Updater v 1.0

Automatically Update Microsoft Access Front End Database Files

 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  Buy Now


The Problem

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. 

The Solution

Access Updater allows you to make whatever modifications you want to your Front End file (the Admin copy). Then, with one click you can "push" updates up to a shared server folder.

Whenever your users load up their database, it will first check for updates. If an update is found, it will download and install the new Front End file before loading the database.

Optionally, you can also check for updates and have them installed automatically at timed intervals (hourly, for example). This is a great option for "unattended" databases, like an Email server.

Order Now

Full Purchased Database

Once you have purchased the full database template, come back to this page and click on the Download button below. This will give you access to the ZIP file containing the Access Updater Template ACCDB file. The WalkThru video above gives you complete instructions on how to integrate this Template into your database setup.

Note: This is Version 1.0 Software!

Please note that this Template is very much "Version 1.0" software. While I have been running it for several weeks in my office and have tested it fully, I cannot guarantee that there are no bugs in it. Before you install it on any mission critical database setups, please make sure you have a full backup of everything beforehand. I will not be responsible for any problems incurred by your use of this software. I have several updates planned already, and you will get FREE copies for all version 1.x updates of this Template. I'll post a list of updates soon.

Learn How This Database Was Built

As of right now, I don't have any plans to turn this into a full Seminar where I show you how to build the database from start to finish. However, if enough of you want to see how it was built, let me know. Post a comment below and say you're interested in a full Seminar for this Template. I'll be happy to record one if there is interest.

Customize For Your Needs

If you would like to discuss customizing this database for your needs, and integrating it into your current setup, please see my consulting page for details on rates and other information.

Additional Keywords

  • update microsoft access front end over network
  • distribute updated microsoft access front end to users
  • roll out a new version
  • copy the new FE from the server
  • How do I distribute updates to a Access database front end
  • Deploy an Access application
  • Distribute Database to Frontend Users
  • Deploy and update a Microsoft Access application with one click
  • Best practices for deploying your Access Database
  • Microsoft Access Front End Updates And Distribution To Users
  • Update a shared database in network shared folder


Got sales or customer service questions about this template? Feel free to post them below. If you have a questions, or you discover a bug or want to suggest a new feature, then please by all means post your comments below.


Dealing w Different Time Zones Upload Images   Link 
Brad Weekley 
23 days ago
I'm trying to use this over different time zones.  I know you say will not work if the time clocks are different.  I guess I was thinking that it would still work on a one hour delay.  For instance, I push an update at 10:00am CT but my user is at 9:00am MT. I thought it won't automatically update until after 10:00am MT. Read More...
Brad Weekley
23 days ago
After creating the module, would I then just change the following in the AccessUpdaterF?

    ' an update is coming, run updater
    If Abort Then Exit Sub
    LastUpdate = CurrentUTC()
Add a Reply
Updater with ACCDE Files Upload Images   Link 
Brad Weekley 
2 months ago
I have a split DB and after watching your Security seminar, I'd like to create ACCDE files for both the front end(FE) and back end(BE).  How would this work with the Updater?
I'm thinking I would have two FE files, one ACCDB (the developers file) and one ACCDE (the one to send to users).  When I want to push an update, would I then create another ACCDE from the ACCDB and then push it from the new ACCDB? Read More...
Adam Schwanz
2 months ago
The updater doesn't do anything with the tables. You're just pushing the FE out.

And it works great, I use mine in this way. When I want to push  out a new update I just use my ACCDB file to save as ACCDE, overwrite the file that I'm updating, and then after it saves, it opens as an ACCDE and you push out the update then.
Richard Rost
2 months ago
^^^ What Adam said. :)
Add a Reply
Access Updater Addendum Upload Images   Link 
Richard Rost 
2 months ago
Added the ability to force your reboot at the top of the hour. See addendum.
Adam Schwanz
2 months ago
Awesome, have been waiting for a way to force reboots to be added :). Thanks
Richard Rost
2 months ago
Force reboots at a timed interval have always been in there - since ver 1.0. I just added a bit of code to make it reboot at the top of the hour instead of whenever it has been an hour since the last reboot.
Add a Reply
Update Backup Multiple DBs Upload Images   Link 
Brad Weekley 
2 months ago
I have both the Updater & Backup databases.  I have multiple databases that I want to use both functions.  Rather than leaving multiple admin DBs open, so the back would run, I chose to create one DB just for the backup function.  Now it copies the folder on the server where all my DBs (Front End)FEs & BEs are located.  Nice!   Read More...
Brad Weekley
2 months ago
As I continue to work this, it appears that I can use just one AccessUpdater.accdb for multiple DBs.   The only issue is you cannot tell which database has been updated in the AccessUpdater.LOG.  As it just shows Admin Pushed Update for both DBs.
So right now, in my server folder, I have two split DBs and one AccessUpdater DB.
Ive pushed updates to both and it appears to work.
Does that make sense?
Richard Rost
2 months ago
Yeah that should work fine. If you rename the Updater DB just make sure you rename it in the VBA code too.
Add a Reply
New Install Upload Images   Link 
Brad Weekley 
2 months ago
Just starting installing on some machines and notice one interesting issue.  If you don't use the most current front end on the initial install, it will not update until the admin pushes an update.  Then it will update and work just fine.  Is that how it should work?  Perhaps always install on a pc with the latest front end would fix this.  Thoughts?
Richard Rost
2 months ago
You should definitely START with the current, newest front-end that you have when you go around doing your initial install.
Richard Rost
2 months ago
Theoretically, as long as you install any version that's older than the one being pushed, it SHOULD work. But I'd go with the latest if you have it available.
Add a Reply
Access Updater Installation Upload Images   Link 
Dennison Vincent 
10 months ago
Hi Rick, after a few attempts, the installation and functionality in my environment was successful. Still have to get the hang of it. My advice is for persons to follow your instructions carefully. For e.g one thing that threw me off was using a different file name which, you too mentioned later down in the video, not to do. Read More...
Richard Rost
10 months ago
Thanks Dennison. Definitely something to look at for the next version.
Dennison Vincent
9 months ago
Thus far, works like a charm. Have installed on approx 40 pcs thus far across 2010, 2013 and 2016 environments.
Add a Reply
ACCDE Files Upload Images   Link 
Chris Bezant 
10 months ago
Have you tried using the updater with accde files yet?
I have and it fails with a file not found message.
All my settings appear to be correct with file names.
Please try it to see if it works. If yours works then I am obviously doing something wrong. My ACCDB file works perfectly.
Richard Rost
10 months ago
Not yet, but that's #1 on my to-do list for the next Updater upgrade. What line throws the error message?
Chris Bezant
10 months ago
I don't know what line. I can't debug a ACCDE file. I get the message when I click the Push Update button.
Add a Reply
Check for Server Drive Upload Images   Link 
Chris Bezant 
10 months ago
Updater working perfectly on my first database.
One of my machines does not always relink all my mapped drives so I put a check in my backup database to check for the existence of source and destination folders. Read More...
Richard Rost
10 months ago
Not a bad idea. I'll put that on the upgrade list. I could also have the updater try to manually restore broken drive mappings. Isn't usually a problem with Windows 8 and up. Older Windows?
Add a Reply
Timer - User Acknowledge Upload Images   Link 
Chris Bezant 
11 months ago
Hello Rick
I just installed Updater using your blank customer database. I set up an admin folder, a remote folder and a user folder. Everything worked perfectly. My next test will be on one of my own databases. Read More...
Richard Rost
11 months ago
You can set that timer to whatever you want - so if you want to give her 5 minutes or even an hour before it installs an update, then that would be a little more user friendly. Sitting there waiting for the user to acknowledge the update would also be something I could add in. At least like "snooze for X minutes" like Windows or Android updates do. Sure. Thanks for the feedback.
Add a Reply

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

8/1/2021Error Messages
7/31/2021Hide Inactive
7/29/2021Event Enrollment
7/28/2021Membership Database
7/27/2021Quick Queries #5
7/27/2021Loop Thru Fields in Table
7/26/2021First Monday
7/25/2021Missing Months
7/24/2021Center Vertically

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: templates access access updater accessupdater update front end   PermaLink