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

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.

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

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.

 

Update Backup Multiple DBs Upload Images   Link 
Brad Weekley 
40 days 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!  
The folder also contains the AccessUpdater DB (which is needed at that location) that is related to just one of the DBs.  What would I need to change in the Updater in order to continue to use the backup method I describe above and create updates via the AccessUpdater DB to the other FE DBs in the folder?  Can I simply change the name of the AccessUpdater to AccessUpdater1, AccessUpdater2, AccessUpdater3,...etc.?  Would that work or is there VBA that would need to change as well?
Brad Weekley
40 days 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
38 days 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

Show All Comments

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:

7/25/2021Missing Months
7/24/2021Center Vertically
7/23/2021DCount
7/22/2021Buy Access
7/21/202164-Bit Access
7/20/2021Relationships
7/18/2021Splash Screen
7/11/2021Access Developer 30
7/11/2021Access Developer 31
7/11/2021Access Developer 31 Lessons
 

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