Days since last backup

[MaleNurse325]

Hello Chaps and Chapesses,
On the main menu screen (Switchboard) I have placed a button that initiates a back up of the database. Works fine, but..
Id like a field under the button that tells the user how many days have elapsed cince last they backed up the database.

Any thoughts?

 

[moke123]

I often have a one record table (tblSettings) where I store such information. Whenever you do a backup, update the table with the date and use datediff to show the number of elapsed days.

 

[Pat Hartman]

I'm with moke on this one. Keep a log table of the backup. Either a one row entry for just the last time or a log of all of the bakups. AND don't force the user to make the decision to back up. Do it automatically either as the database opens or as the last step before closing. I always have the switchboard or login form loaded. When I open other forms, I hide the initial form but since it is the first form to open, it is always the last form to close which gives me a place to do the backup either coming or going

Have your code check the last backup date and force the backup if the last one was more than 24 hours ago or whatever time frame you want. The backup log table needs to be in the BE so that all users are working off the same date.