Crashing Query Files Upon Import

[John Phelan-Cummings]

Why is it that whenever I import forms, tables, modules, reports, and query files that all my query files import corrupted. When I open up (in design view) a query file all my field names begin with an "Expr#", I.e., "Expr8: budglabel". I then have to go into each query file and remove the Expr# referenced number in
front of each field name. Everything works afterwards until the next new database import.

jphelan

 

[Jeanette Cunningham]

If you are not connected to the tables in the backend when you open the forms and queries, this will happen.

Jeanette Cunningham

Why is it that whenever I import forms, tables, modules, reports, and query files that all my query files import corrupted. When I open up (in design view) a query file all my field names begin with an "Expr#", I.e., "Expr8: budglabel". I then have to go into each query file and remove the Expr# referenced number in
front of each field name. Everything works afterwards until the next new database import.

jphelan

 

[John Spencer]

I think it is due to the queries checking for the presence of the tables and
fields during the import process.

Try a 3-step import and see if that cures the problem.

Try importing the tables first.
Then importing the queries.
Then importing modules, forms, macros, and reports.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Why is it that whenever I import forms, tables, modules, reports, and query
files that all my query files import corrupted. When I open up (in design
view) a query file all my field names begin with an "Expr#", I.e., "Expr8:
budglabel". I then have to go into each query file and remove the Expr#
referenced number in front of each field name.

Everything works afterwards until the next new database import.

jphelan