Export Linked Tables using Transfer Database Macro

Posted on 2007-10-09
Last Modified: 2013-11-27
I am using Access 2003 and I have a query re Exporting of Info.  If my database is not split and I use Transfer Database in a Maco for each table (20 of them) to be transferred, all works perfectly.  But if the database is split (which it usually is) then it exports the link to the tables, not the actual table.  I need it to export the actual data (as it does when it isnt split).  Any suggestions please.  I realise that I will prob have to enter the full path of the BACKEND but to do this for 20 tables for each installation is very time consuming as the path will differ for each installation.  Any suggestions please.  Unfortunately i know very little code.  Just a little background, this information is being exported so that it can be emailed to another branch for importing into their database.   (All works wonderfully if the database is not split but there are often more than 5 users and we need it split)
Question by:AnnetteDavid
    LVL 77

    Expert Comment

    Create a query on the table and export that instead.

    Author Comment

    Thank you for this, but if it is exported as a query, will it not create a query on the exported side instead of a table or do I have have to run a Make Table Query as well and then Delete each Table afterwards - many thanks for your help - much appreciated
    LVL 77

    Accepted Solution

    Just use transferdatabase to export the query but make sure you set the object type as table in the macro arguments.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now