The dual file system has two advantages.I've seen similar to KenHigg's version control before and know other admins that use similar. Works well, but requires two database files.
I use a variation of Bob Larson's file - https://btabdevelopment.com/free-access-tools/ - does need to create a script, but it creates the script itself and deletes the script on startup.
1. It can be set to disallow the front end from being opened directly.
2. It allows revision to be made without forcing people off the system. It just waits until they close and reopen the front end. We also had a log times that would report if a Frontend hadn't been opened for a period.
Couple that with a SQL Server and you can manage the system completely without User participation.
Last edited: