PC Review


Reply
Thread Tools Rate Thread

in Access 2007-TransferDatabase action will not work.

 
 
Donna
Guest
Posts: n/a
 
      23rd Mar 2010
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2007 Macros - SendObject action, Message Text action argume rgille Microsoft Access Macros 8 28th Feb 2012 07:29 PM
Temp Tables in Access 2007, Transferdatabase warnings Dale Fye Microsoft Access VBA Modules 1 14th Jan 2010 01:56 PM
Access 2007 - DoCmd.TransferDatabase not saving UID and PW Hal Levy Microsoft Access External Data 2 4th Jun 2009 05:48 PM
access 2007 and transferDatabase jsrogol Microsoft Access Form Coding 2 25th May 2009 06:02 PM
What Happend to 'TransferDatabase' in Access Macros 2007 =?Utf-8?B?U2lyT3ds?= Microsoft Access Macros 1 14th Aug 2007 09:58 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:59 PM.