Export table(s) that are linked

P

Paul Sondervan

Hello

I've got 2 databases
- Toets.mdb (queries, forms, etc.
- ToetsData,.mdb (only tables

I've linked in Toets.mdb with the tables in ToetsData.mdb
Everything works fine, creating new rcords, updating, etc
This customer has to export 2 of the 8 tables every month and send it to another costumer
I've made in toets.mdb a form. The customer only has to click "OK" and the export is made in Export.mdb.
The probelem is that when I do an export (with TansferDatabase) in Toets.mdb, I get an empty 'linked' table in the Export.mdb

Is there a solution to make this work and the data in the table is transfered to Export.mdb

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Data from an access table to a pre-formatted excel template 1
Export to Excel a linked 1:Many Table 4
Conneting to SQL server, Need advice 4
Import & export tables based on table data and docmd 14
Linked Table - Query Table List Missing Fields? 1
xml exports misses recent data 0
Split database- linking tables 2
Automate update linked table & export query results to Excel 0

Top