access2003 queries exported in another access2003 db (empty) lost

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi

i have trouble exporting access 2003 queries in a external db (empty).
when i export (with drag and drop or with export menu),the queries lost all
the links inside (form table to table ecc..) becouse in the target db the
tables does not exist!!!
(i use empty db to menage the fix on my program)

before 2003 i use 97 and i don't have this problem.
so... what can i do??

tnx
 
This is normal and expected. When you open a query, it has to have the
tables or queries it uses in place to be able to get information about them.
It doesn't matter which you export first, the query or the tables, they have
to all be there when you open the query in design view or try to run the
query.
 

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

Access Access Select Query is cleared out after exporting 5
Link Tables and Select Link 2
Exporting Access 2003 queries causes problems with definition 4
Access 2003 db's & problems exporting query to Excel 1
Deleting Objects in another database (.mdb) 6
Transfer/export tables to another DB 6
Acc export: getting around Excel row limits 6
Exporting Tables/Queries 21

Back
Top