Editing query error message

I have an error that comes up everytime i try to edit a
query using the query wizard. It says "This query cannot
be edited by the Query Wizard". I have rebuilt the actual
query using SQL, and deleting the sheet and rebuilding the
query in the wizard, and each time I go back to edit it
the error comes up again, for no an unknown reason. If i
don't specify any limitations it runs, but if i specify I
only want certain data between 2 dates, it brings up the
data requested, but if i go back to edit that query in the
wizard it won't let me! I need help so my end users can
use this report!
Thanks!

"christen May Co." wrote ...

> I have an error that comes up everytime i try to edit a
> query using the query wizard. It says "This query cannot
> be edited by the Query Wizard". I have rebuilt the actual
> query using SQL, and deleting the sheet and rebuilding the
> query in the wizard, and each time I go back to edit it
> the error comes up again, for no an unknown reason. If i
> don't specify any limitations it runs, but if i specify I
> only want certain data between 2 dates, it brings up the
> data requested, but if i go back to edit that query in the
> wizard it won't let me! I need help so my end users can
> use this report!

I don't think the message is in response to an 'error'. Rather, I
think it means the SQL is too complex for the wizard to deconstruct.
If you OK the message, the MS Query UI opens, in which you can edit
the query using either the 'clicky-click' Tables and Criteria GUI or
by editing the SQL directly. After editing, if you close MS Query the
data on the Excel worksheet should be updated i.e. no need to delete
the query/sheet and recreate etc.

Consider automating the process for your users by writing some VBA to
change the SQL or to add parameters. You may get some ideas from Dick
Kusleika's site:

http://www.dicks-clicks.com/excel/E...5.htm#ChangeSQL

Jamie.

--

Raghu,
I know this eliminates the error, but my end users are not able to edit their queries using Microsoft query, because they do not know how, they need to use the wizard to edit their queries because they do it so often, any one have any other ideas?

"Raghu Prakash" wrote:

> Hi christen,
>
> this message results when Excel tries to load
> MasterMine's query into a query wizard for editing, instead of going
> directly into MS Query which is more capable of handling complex queries.
> To speed up loading of MSQuery and remove this annoyance, do the following
> one time in Excel:
>
> On the 'Data' Menu, select "Get External Data..." and "New Database Query"
> On the dialog that comes up, find the checkbox for "Use the Query Wizard to
> create/edit queries" at the bottom and uncheck it.
> Exit this dialog by hitting "Cancel".
>
> Please let me know has this helped You...
> Thank you...
> Raghu...
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>