Using TransferDatabase to transfer tables between external access databases

[Marco Castro]

I'm trying to create a small vb function from inside an access database that
will copy a few tables that I am using to another access database.
Currently the tables that I want to copy are linked. If I try to use
TransferDatabase to export them they end up creating a link at that database
instead of 'real' tables.
I tried to specify the full path of where the real tables are but I keep on
getting an error that they can't be found. So either I'm getting the syntax
for it wrong or the TransferDatabase function only accepts local objects.
Does anyone know how I can get around this? Putting the code where the real
tables are and running it from there is not an option.

Thanks for any help.

 

[Liz]

The following quote is from Access Help:
"if you import a table from another Microsoft Access
database (.mdb) that's a linked table in that database, it
will still be linked after you import it. That is, the
link is imported, not the table itself."
Therefore your table that is linked will always be linked
and not imported.
I would suggest running a make table query and using the
new made table as the Transfer Database table if you want
to disregard the link and have the table information
imported to the other db. Just remember that the Make
Table query will need to be run before each transfer so
the info is updated (if this is something that would
otherwise be an issue)