AnnetteDavid
asked on
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)
Create a query on the table and export that instead.
ASKER
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.