Exporting queries for modification purpose and or backup

[Guest]

Hi all.
We recently started testing Access 2003 to migrate all our internal
appliances under new version.
Till now all working fine but we got a minor concern.
In Access 2000 u could export queries in a temp db (say for editing or
simply backup) without exporting tables involved in query, in Access 2003
when we try to export very same queries the final result in temp db is a
series of Expr(x) name of original field. Is this feature by desing? ie if i
want to make a backup copy i have to export tables structure related to
queries?
Hope it makes sense
Thx in advance for any reply.

 

[Jeff Boyce]

Claudio

I don't remember ever being able to save a query without the related tables,
but ?!?

If you want to save a query, another approach would be to save the
SQL-statement as a text file. Then, in a new db, you could "paste" the text
into a SQL-design window and get the query back (provided, of course, that
the tables referred to in the SQL exist in the new db).