An investment in knowledge
pays the best interest.
-Benjamin Franklin
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  

Updated Production Schedule
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   9/22/2018 12:01:00 AM
Updated Production Schedule
Updated 22 September 2018

This is a guide to what's coming up next, in order of release.


I just finished Access Developer 11.


Right now I'm doing my best to release one new Access Developer lesson per week. I'm just now getting over bronchitis, so I've been a little delayed, but I hope to have D12 and D13 ready to go by the middle of next week.

During this time, I'm also going to be updating my Level 1 Beginner courses for all of the Office apps: Word, Excel, PowerPoint, Outlook, and new classes for Publisher. These are long overdue. I also need to make Expert lessons for Word, and VBA lessons for Excel.

Windows 10 has also surprisingly been high on the WAITING LIST so I'm going to try to get some lessons out for that, but Microsoft is planning a new major release for Windows next month in October, so I'll probably wait until that's out.


And, of course, as a disclaimer, NOTHING listed above is set in stone. These are ESTIMATES ONLY. The tutorials I release may change at any time depending on demand, need, customer interest, or even just my whim. I like to keep you guys "in the loop" as best I can, but remember that things may change.

Permanent Link
Keywords: production schedule

Access Split Databases Comment from Chris B @ 5/12/2014
Hello Rick
I like to split databases to facilitate updating front ends but the two concerns I have for my less techy users are:
Compacting the back end - how can I do that from the front end?
The other concern is when table structure changes, how do I manage that? Is there a clever way to re-link the tables after an update to the front end? Yes, I know about the Link Table Manager but that is too scarey for some of my users.
So a seminar on managing split databases would be very welcome.

Reply from Richard Rost:

Compacting the back-end is something that's done as a weekly maintenance event, by you, manually. There is VBA code I've tried using before to compact it, but it's unreliable in my opinion. This is just one of those things I recommend you schedule some time for, once a week (or even once a month, depending on how much your db gets used), kick everyone offline, and quickly run a compact on the server.

Table changes can be manipulated using DAO (recordsets) which I haven't covered yet, but I will when I get to the Developer series. You can change them with SQL commands (see SQL Seminar, Part 3) but those commands have to be issued on the "server" machine, and not from a linked database. I've done it before using a "main menu" form that stays open on the server and can issue remote commands like this. Kind of tricky, but it works. DAO is much better.

I'll add these two suggestions to the list (along with the other requests I've gotten) and perhaps I'll put together more on this in an upcoming seminar.

Show Just This Thread        Post Reply

Add Your Comments or Subscribe
If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
  Your Name:  Required
  Your Email:  NOT Public


Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 4+9:
  Notify me when the News is updated.
  Remember Me for my next comments
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard



Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
About Us
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Gift CDs
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

YouTube Channel    LinkedIn

Blog RSS Feed   
Richard Rost Microsoft MVP