query error message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

would like some help with the following error message when trying to write an
SQL query
'parameters are not allowed in queries that can't be displayed graphically'

thanks
 
Jeff

I'm only using logic here, but the only type of query that can be displayed
graphically are SELECT or CROSSTAB.... UPDATE, DELETE, CREATE are not
allowed I suspect???

Just a shot in the dark.

Additionally, if you are accessing SQL by ODBC then put the parameters in
MSQuery instead. (If you are using the wizard, the last screen allows you to
edit the query in MSQuery)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
Back
Top