Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Courses > Access > Templates > Access Updater >
Back to Access Updater    Comments List
Upload Images   Link   Email  
Access Updater Addendum
Richard Rost 
            
3 years ago
Added the ability to force your reboot at the top of the hour. See addendum.
Adam Schwanz 
            
3 years ago
Awesome, have been waiting for a way to force reboots to be added :). Thanks
Richard Rost OP 
            
3 years 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.
Brad Weekley 
     
3 years ago
Can you help me understand why we need force reboots?
Adam Schwanz 
            
3 years ago
OH, well then... I'm just going to pretend they haven't ;)

@Brad - Numerous reasons you'd want to be able to force reboot remotely. The two biggest ones would be if you needed to get someone out of a table/form for backups or some kind of data changing query. Or if they never close access and never get the updates you push out, this forces them to :).
Brad Weekley 
     
3 years ago
Ok. That makes sense, but once an hour?  That seems like it will cause issues during the work day when other users are in the middle of using the database.  Im missing something here.  Right now, I have an On Timer event that forces a Quit at 3:30am.  So Im the morning when the users come to work, it forces them to update via the Updater.  That was all part of the Updater or BackUp databases from Richard.  
So, Im still puzzled as to why you would want to reboot either the FE or BE once an hour.
Richard Rost OP 
            
3 years ago
Brad, in my case, I have a "server" PC which runs all of the automated processes for my business: pulling orders down from the web site, sending out auto emails, etc. It's constantly doing "stuff." Access is a wonderful application, but it's not really designed to run for days or weeks at a time constantly doing "stuff." It's got memory leaks, especially if you're using a database that you started building in 2004 and slowly upgraded over the course of 17 years. Like Scotty says, "The energizer's bypassed like a Christmas tree, so don't give me too many bumps." Rebooting once a day is usually more than enough, however I've got mine set to restart every hour, on the hour. This way the database always stays nice and fresh, and I've got an audible clock in my office. :) But yes, for the average office worker, forcing a reboot at, say 3am is usually good enough. They're guaranteed to get any updates at least once a day, and you shouldn't have to worry about memory leaks.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Updater.
 

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
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
PCResale.NET
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
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 12/5/2024 12:11:14 AM. PLT: 1s