[AccessD] Queries are messed up!

Hi Barb:

This only happen in a query is when some of the fields or tables requested
are not available in the current DB, in this case the clients site. 

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Barbara Ryan
Sent: Thursday, February 08, 2007 4:21 PM
To: Access List
Subject: [AccessD] Queries are messed up!

In an Access 2002 application, when I need to distribute database object
changes, I copy all of the modified objects into a blank database and email
it to client sites.  They then click a push button in their application
which imports all of the objects.

Everything has worked great (for years) until now ---- if a query is
included in the update, it will import into their application without any
relationships (i.e., there are no "lines" between tables) when the query is
viewed in design mode on their computer.  Also, even if the query only
contains one table, all of the selected fields are listed as "Exp1", etc.
For example, what used to appear as "EmpNo" now displays as "Expr1:EmpNo".

I have duplicated this problem myself by importing the objects into another
database on my computer.

We (the clients and I) have recently upgraded to Access 2003.  

Any ideas?  Or should I call Ghostbusters again :-(

Thanks,
Barb Ryan
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com