Thanks, Daniel. What I really want to do is EXPORT to another database.
And I do not want to have to enumerate by name every table that is in the
source database. What I want is a vba procedure that will loop through all
the table names in my source database an export each to a specific, named
destination mdb database. Can you help me with this?
and combine it with the DoCmd.TransferDatabase to do exactly what you want.
Basically list each table and Transfer them one by one.
--
Hope this helps,
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.