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

Automatically Update Microsoft Access Front End Database Files

 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark 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.


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.


For internal use only. This template does NOT come with a royalty-free license. You may only customize the database for your business needs and for use within your organization. You may not resell or distribute it to others without express written permission. Contact me for additional information on obtaining a license to distribute if you plan on including this template in a database you are reselling. 

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.


UpdaterTimerMenu Upload Images   Link  
Ina van Rooyen 
13 days ago
I installed the updater and did everything exactly as in the lesson.  None of the timers is and my MainMenu does not load at the end.  It just sits on the Access Updater form.
I went through the whole process twice.
Ina van Rooyen
12 days ago

Ina van Rooyen
12 days ago
....None of the timers is working and my MainMenu does not load automatically.
Add a Reply
ACCDE Files Upload Images   Link  
Brent Rinehart 
2 months ago
Good evening Richard I think with all the changes I am making to my database I get so many complaints from the users that they have to copy another version to their desktops, boo hoo lol so I think it might be time for this Access Updater but I only give out accde files and want to see what the time frame is on the next version that will include this?
Richard Rost
2 months ago
It will work with ACCDE files right now. You just have to manually create the ACCDE file yourself first. The planned upgrade is to have Updater CREATE the ACCDE file for you and save you a step. See the planned upgrades page:

- support for ACCDE files - AccessUpdater.ACCDE
     - have Access automatically CREATE and distribute an ACCDE file (if this is possible)
     - NOTE that Updater currently DOES support distributing YOUR database as an ACCDE file. It's just that the
             AccessUpdater.ACCDB file isn't an ACCDE yet.
Brent Rinehart
2 months ago
Thank You for the info
Add a Reply
Dealing w Different Time Zones Upload Images   Link  
Brad Weekley 
5 months 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
5 months 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

Show Older Comments...
View in Table Format

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:

12/8/2021Access Expert 6
12/8/2021Access Expert 5
12/8/2021Access Expert 4
12/8/2021Access Expert 3
12/8/2021Access Expert 2
12/8/2021Access Expert 1
12/8/2021Access Beginner 9
12/8/2021Access Beginner 8
12/8/2021Access Beginner 7
12/8/2021Access Beginner 6

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