How to create a macro or VBA project to backup tables to floppy

[stotzc001]

I want to create a button to backup tables in my database to floppy. I have three tables [Personnel], [Flight Data], [Training Data]. I am capable of using macros or inserting VBA code. I also need to check to make sure that the floppy has enough room before I copy the file.

 

[MichaelRed]

Using a floppy to back up a data base, even checking for the necesary space requirement sounds like an idea from the (far) past. Even a moderate db whii quickly exceede the capability of the "traditional" floppy. In any reasonable system, there should be alternatives, such as another "PC" connected via some network arrangement, or ad least a R/W cd or dvd.

Still, the general approach is quite similar. Using VBA , open (or create and then open) a (back-up) db. If you are creating the db anew, you will need to copy (the structure only) of the tables to the db. Using SQL / Query (or queries) simply append the tables to the (back-up) db.

While there are numerous variations on the theme, (create a new db for each backup; create new tables in a common db for each back up; update existing tables to reflect the operational recordsets; etc.) the concept is more-or-less the same. In some instances, actually checking for physical availability of the target media (either in existance, or available free space is actually done, while many schemes just rely on the system errors to provide notification that the operation failed and using this as a prompt to replace the media.

If you "insist" on being proper in checking for the available space on the target device, see "FreeSpace" in hte ubiquitous {F1} (a.k.a Help) for details.





MichaelRed
m.red@att.net

Searching for employment in all the wrong places