Backup Database on close

[Zorkmid]

Hi all is there a way that I can configure myfront end to make a backup of the backend everytime it closes?

 

[SOS]

Is there a particular reason? Is this backend not on a network drive where it is backed up by IT nightly?

 

[Zorkmid]

It is on a network drive, but our IT department is not the worlds most reliable and we've had trouble with data loss before.

 

[namliam]

You can, you could make a bit of code that "on close" of your main form makes a copy of your database into any folder the current user has access to...

You can use the VBA native FileCopy or use a much more complicated FSO (FileSystemObject) to do it.

 

[SOS]

1. Trying to copy the database when a database has it open can be touchy.

2. How do you propose to copy the database backend if all of the users need to be out of it first? How will the backend know that nobody is left in it?

You'd be better off using Windows Scheduler to make a copy at night when nobody is around. That is my opinion.

 

[namliam]

2. Look for the related LDB file to exist or not.

 

[ghudson]

Maybe this will help if you just want to export the data tables... Export All Database Objects Into Text Files or you could zip a copy of the database but you really do not want to do anything if other users are in the database.