Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 917
  • Last Modified:

Export Linked Tables using Transfer Database Macro

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)
0
AnnetteDavid
Asked:
AnnetteDavid
  • 2
1 Solution
 
peter57rCommented:
Create a query on the table and export that instead.
0
 
AnnetteDavidAuthor Commented:
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
0
 
peter57rCommented:
Just use transferdatabase to export the query but make sure you set the object type as table in the macro arguments.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now