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  Buy Now

Resources

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.

Updates

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.

License

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

Questions?

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.

 

ACCDE Files Upload Images   Link 
Brent Rinehart 
15 days 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
14 days 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
14 days ago
Thank You for the info
Add a Reply
Dealing w Different Time Zones Upload Images   Link 
Brad Weekley 
3 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
3 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()
    DoSaveSettings
Add a Reply
Updater with ACCDE Files Upload Images   Link 
Brad Weekley 
4 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
4 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
4 months ago
^^^ What Adam said. :)
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.
 
Subscribe
 

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

10/21/2021Conditional Formatting
10/20/2021Text Messages
10/19/2021Late Binding
10/18/2021Open Form
10/17/2021Date Only?
10/16/2021Relink Tables
10/16/2021Access Developer 34
10/16/2021Access Developer 34 Lessons
10/16/2021Access Developer 34
10/10/2021Copy Text from Field
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
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