Importing objects into Access 2002 from 2003

C

Connie

I am attempting to import tables, queries, forms and reports from an Access
03 database into an Access 02 database. The database is split, and has user
level security.

The tables import fine, but when I bring in the queries, every single field
is renamed with an Expr1(fieldname), Expr2(fieldname), etc.

As it is a fairly large database, it would be very time consuming to change
all of the fields to the correct name. It doesn't seem to matter whether I
import it into 02 or 03, I get the same results. Does anyone know how to
avoid this from happening?

Thanks
Connie
 
Top