Exporting queries for modification purpose and or backup

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

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 :o
Thx in advance for any reply.
 
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).
 
Back
Top