query error message

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
 
N

Nick Hodge

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

parameters 4
Microsoft query won't allow parameters 4
Parameters are not allowed in queries that can't be displayed grap 1
Error on Access Query 10
MS query return multiple columns in Excel 1
Email Bounce Error 3
Access Print Files from Query Results 0
Access Overflow error 3

Top