Exporting a group of tables

[Katrina]

I have a database set up as a front-end, back end
relationship. I also have a master copy of the database
that contains everything. I have a macro that will export
all of the forms, reports, macros and queries, but i
cannot figure out how to export all of the tables.

The problem comes when access trys to delete the old
table. It will not delete it because of the relationships
to other tables. I know that I could copy the database
and use the database splitter, but I would like to find a
way to do this with visual basic or a macro. Anyone have
a suggestion on how to get around the problem of the
relationships in exporting the tables?

 

[david epsom dot com dot au]

If you want to use VB/DAO, you can delete tables like this:

codedb.TableDefs.Delete "mytablename"

(it deletes relationships and indexes at the same time)

you can't delete a table without breaking the relationships

(david)