Export Tables to zip file when database closes

[PietKruger]

Hi,
I want all the tables of my database to export to a zip file when the users exit the database. this will serve as a sort of a backup of the data. Is this possible? if so, how?

Piet

 

[DJkarl]

Possible yes...but totally impractical. You would need to export each table to it's own file (text file or a spreadsheet). Then compress those files into a single zip file. You should have a split FE / BE setup and then either the FE could backup the BE or hopefully the BE is on a server and the server itself is backed up nightly and you wouldn't need to backup the BE at all.

 

[PietKruger]

Hi, thanks for your quick reply.

The database will run on a stand alone pc. i don't know anything about FE / BE. could you please explain? I'm new to database designing.

Piet

 

[Darth Vodka]

Hi, thanks for your quick reply.

The database will run on a stand alone pc. i don't know anything about FE / BE. could you please explain? I'm new to database designing.

Piet

search the forum

or here's a link

http://www.members.shaw.ca/AlbertKallal/Articles/split/

 

[DCrake]

Simple Software Solutions

Please find the attach demo to resolve your issue. Remember to read the HOWTO document first.

CodeMaster: