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.
"Andrea Corni (softintime)" wrote:
> 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
>
>
|