Automatic Backup When Last User Closes.

[JohnL7]

Hi All,

I've searched for ages looking for threads on backing up a database, and even found one which was asking exactly what I need but without solutions given.

I have a split database with BE and FE, which is used by about 20 users. When the last user closes the database I would like the database to be automatically backed up (e.g. when no one is using it). I've found threads on scheduling a backup, it the middle of the night for example, and other threads on backing up while users are logged on, but I'm not really keen to use these approaches.

Any ideas??

John

 

[Dennisk]

when all users have exited an Access db the corresponding locking file will be removed. So on exit, open another access db that runs an autoexec macro that run code to test if the locking file is present or not. If not present then backup.

 

[JohnL7]

Thanks Dennisk,

This sounds good!! I'm still very much learning the subtleties of Access. Do you know of any examples of code needed.

Many Thanks

John

 

[Dennisk]

No, however look up OpenDatabase Method, Shell, Shell Execute ( these two should be executed via a Windows API to run your backup) as The Shell function runs other programs asynchronously. This means that a program started with Shell might not finish executing before the statements following the Shell function are executed.

 

[JohnL7]

Hi Dennisk,

Thanks for the tips. I'll do a bit of research into those suggestions.

Many Thanks for your help

John