sambo
Registered User.
- Local time
- Today, 15:30
- Joined
- Aug 29, 2002
- Messages
- 289
I have 9 Inner Joined Tables that I would like to export to a temporary database every night via code.
Here is the long and short. I'm doing a data dump once per day across networks. I don't want to dump the entire .mdb file (its too big), so I'm just going to get the data I need and store it in a new (temporary) .mdb that includes only the data tables (not the reference tables, forms, reports, or any other bells and whistles.) This should cut way down on the size of the file to be transfered.
I would like to export each of the nine tables from "old.mdb" to "new.mdb" via code.
Here is a look at the tables that I would like to export.
Any suggestions..
Here is the long and short. I'm doing a data dump once per day across networks. I don't want to dump the entire .mdb file (its too big), so I'm just going to get the data I need and store it in a new (temporary) .mdb that includes only the data tables (not the reference tables, forms, reports, or any other bells and whistles.) This should cut way down on the size of the file to be transfered.
I would like to export each of the nine tables from "old.mdb" to "new.mdb" via code.
Here is a look at the tables that I would like to export.
Any suggestions..