[AccessD] Queries are messed up!

That's what I thought.....however, the client has all the tables referenced 
in the queries.  I even ran on test on my computer with the same weird 
results.

Barb

----- Original Message ----- 
From: "Jim Lawrence" <accessd at shaw.ca>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Friday, February 09, 2007 9:05 AM
Subject: Re: [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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com