Errors with ACCESS

[Paul Larick]

Hello-

I recently had the XP version of Office installed on my
computer and have noticed, at least, two consistent
problems with ACCESS 2002, that didn't appear with the
previous version, ACCESS 2000.

I am wondering whether these are consistent problems with
ACCESS 2002, and how to fix them.

1. If I want to process several tables, with similar
formats, I will copy and paste a single query, just
changing the "from" table and name of the new query.
Now, attempting to run the queries or view them in SQL,
the whole database crashes.

2. I wrote a query, in SQL, that uses a union query as a
subquery to a normal select query. When I save this
query but go back to edit it, I notice that ACCESS has
changed the SQL, dropping the "grouped" by statement in
the outer query and adding "DISTINCT ROWS". The
resulting query doesn't work as originally intended.

Thanks for your help.

Paul

 

[[MVP] S. Clark]

1. Try copying just the SQL, and create a new query. Paste the SQL, and save
the query, changing the from. See if the crashing stops. It probably
wouldn't hurt to repair and compact.

2. A union query as a subquery, huh? Good luck with all that. Since I'm
not a fan of either, my recommendation is to either restructure your tables
or breakdown the query to more queries, until the desired functionality is
achieved.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-