Rebuilding a Clean Database

[Joe Wroblewski]

I'd like to clean up a database I've built over time by starting with
clean empty tables and only the queries, forms, reports, etc that I
really use.

It would be nice to have a vb routine that allowed me to load up a list
of table, querie, form, etc, names to rebuild the database, hopefully
getting rid of debris that i've left over time.

My guess is that either the DoCmd.TransferDatabase or the DoCmd.OutputTo
command is where to start. Where can I find examples of the syntacks
for these command?

Thanks!

 

[Douglas J. Steele]

There are samples in the Help file. Look for TransferDatabase or OutputTo.

There are also 3rd party tools available to help in this regard.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



I'd like to clean up a database I've built over time by starting with clean
empty tables and only the queries, forms, reports, etc that I really use.

It would be nice to have a vb routine that allowed me to load up a list of
table, querie, form, etc, names to rebuild the database, hopefully getting
rid of debris that i've left over time.

My guess is that either the DoCmd.TransferDatabase or the DoCmd.OutputTo
command is where to start. Where can I find examples of the syntacks for
these command?

Thanks!

 

[John Vinson]

I'd like to clean up a database I've built over time by starting with
clean empty tables and only the queries, forms, reports, etc that I
really use.

It would be nice to have a vb routine that allowed me to load up a list
of table, querie, form, etc, names to rebuild the database, hopefully
getting rid of debris that i've left over time.

My guess is that either the DoCmd.TransferDatabase or the DoCmd.OutputTo
command is where to start. Where can I find examples of the syntacks
for these command?

Thanks!

If you're doing it manually, it's probably actually easier to use the
user interface: create the new database and use File... Get External
Data... Import to import the selected objects.

To identify which objects are mutually dependent and which are no
longer used, it's easiest to get one of the third-party programs
written for the purpose:

Free: http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com