D
Donna
I'm trying to transfer a table between 2 databases. I've been using these
databases for the past 3 or 4 years. They are 2003 databases and now we are
using Office 2007. I can't seem to convert them, but that is another issue.
I have set the trusted location of the folder and all its subfolders for
both databases. I have made sure that macros are enabled. I even went to the
registry and changed the sandbox from 3 to 2.
The first action in the macro is to TransferDatabase. When I step into it,
that is where it stops working.
I am trying to send the table named InputData (from a child database) to a
master database table named B1. In the master db there is an existing table
named B1 that gets overwritten each time the table gets transferred. The
macro is deleting the B1 table in the master database but is not replacing it
with the new B1 table.
Has anyone had trouble like this? Do you know a solution? What am I missing?
Thanks for your help,
Donna
databases for the past 3 or 4 years. They are 2003 databases and now we are
using Office 2007. I can't seem to convert them, but that is another issue.
I have set the trusted location of the folder and all its subfolders for
both databases. I have made sure that macros are enabled. I even went to the
registry and changed the sandbox from 3 to 2.
The first action in the macro is to TransferDatabase. When I step into it,
that is where it stops working.
I am trying to send the table named InputData (from a child database) to a
master database table named B1. In the master db there is an existing table
named B1 that gets overwritten each time the table gets transferred. The
macro is deleting the B1 table in the master database but is not replacing it
with the new B1 table.
Has anyone had trouble like this? Do you know a solution? What am I missing?
Thanks for your help,
Donna