Programaticlly load/unload data

[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.

 

[Douglas J. Steele]

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.

 

[Mike P]

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!

 

[Douglas J. Steele]

I haven't worked enough with Access 2007 to know what that option does, but
splitting is pretty trivial to do manually. Check what Tony Toews has at
http://www.granite.ab.ca/access/splitapp/index.htm

Access has a Linked Table Manager built into it (sorry, I can't remember how
to invoke it in Access 2007), but most developers add their own routine to
relink the tables. See http://www.mvps.org/access/tables/tbl0009.htm at "The
Access Web" for one approach.

 

[Mike P]

Great stuff Doug! I have successfully split the data from the program so I
can now have a production and test back end! Thank You ! ! !

Another helpful link is - http://support.microsoft.com/?kbid=304932