Programaticlly load/unload data

  • Thread starter Thread starter Mike P
  • Start date Start date
M

Mike P

I am debugging VB and need to keep my data safe. Is there a way I can export
all of the data in all of the tables in the database from a program. Then,
when I am done debugging, pull all the data back into the access program i am
writting?

Pseudo code:
unload (or copy) all data in all tables to an external location
debug program which will corrupt the current data in the program
delete all the data in program that has been corrupted during debugging
process
reload the data from the external source that was exported.

I have about 50 tables, so I'd like to just write a loop in code that will
do this. Any ideas and some sample code would be greatly appreciated!

Thanks,
Mike P.
 
Split your application into a front-end (containing the queries, forms,
reports, macros and modules) and a back-end (containing the tables and
relationships). Have a dummy back-end for use while developing.

That's how Access applications should be developed anyhow.
 
Awesome idea! Sounds like a good design pattern that I did not follow during
development. Does that matter in Access 2007? I am new to Access
programming but not new to programming (more a C/C++ guy). This Access 2007
app I am building has a bunch of code, models and forms with VB in it. Is
the process as simple as selecting Database Tools -> Move Data -> Access
Database. And if it is that easy, how to I switch the db backend back and
forth from test to production?

Thank you!
 
Back
Top