access2003 queries exported in another access2003 db (empty) lost

  • Thread starter Andrea Corni (softintime)
  • Start date
A

Andrea Corni (softintime)

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
 
K

Klatuu

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.
 
Top