Copying a db, but including only Tables that match a Spec

[teach314]

hi
DoCmd.TransferDatabase is a great way to COPY and RENAME an mdb file. What is an efficient way to COPY and RENAME the mdb file including all Modules, Forms, Queries, etc., but only including Tables that match a SPEC (for example, "tbl_???_Values_*") ?

Thanks for any hints

 

[smedvid]

Perhaps write some VBA Code that can create a cursor (record set) of tables from tabledef object, then look through that object and perform command(s) as needed. VBA Coding experience required... Just one thought... htwh..

Steve Medvid
IT Consultant & Web Master