Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Courses   Seminars   Templates   Help   TechHelp   Forums   Order   Contact   Logon  
 
Home > Templates > Access > 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 full, 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.

 

Access Updater Installation Link 
Dennison Vincent 
12 days 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    
11 days ago
Thanks Dennison. Definitely something to look at for the next version.
Add a Reply
ACCDE Files Link 
Chris Bezant     
24 days 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    
24 days 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    
23 days 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 Link 
Chris Bezant     
25 days 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    
25 days 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 Link 
Chris Bezant     
28 days 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    
28 days 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

Post a New Comment or Question
 
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/26/2020Overlay Data on a Map or Image
10/26/2020Access Map Overlay Template
10/22/2020ABCD Part 2: Core Database
10/21/2020Consolidate Tables with Helper Data
10/20/2020Is Microsoft Access Going Away?
10/12/2020Store Multiple Phone Numbers
10/10/2020ABCD Part 1: Core Database
10/10/2020Create Your Own Custom Function
10/8/2020Update Query from Another Table
10/5/2020Access Business & Contact Database
 
 

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
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search The Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

YouTube Channel    LinkedIn

Blog RSS Feed   
Keywords: templates access access updater accessupdater update front end   PermaLink