Access 2003 with SQL 2005 - Query Parameter

[cgwozdz]

I am new to SQL Server and I'm trying to create a parameter query in the View
folder in SQL Server. I used @name as well as a ? mark for the parameter,
but I continue to get a message stating that "'Parameters' cannot be used in
this query type."

After I get the error, I am able to run the query - the parameter dialog
pops up and the result set is accurate. However, when I try to save the view,
a dialog pops up stating the I must declare the scalar variable "@name".

I click OK and receive the message "User canceled out of save dialog".....

What am I missing?

Thanks,
_____Casey G.

 

[Michael Gramelspacher]

I am new to SQL Server and I'm trying to create a parameter query in the View
folder in SQL Server. I used @name as well as a ? mark for the parameter,
but I continue to get a message stating that "'Parameters' cannot be used in
this query type."

After I get the error, I am able to run the query - the parameter dialog
pops up and the result set is accurate. However, when I try to save the view,
a dialog pops up stating the I must declare the scalar variable "@name".

I click OK and receive the message "User canceled out of save dialog".....

What am I missing?

Thanks,
_____Casey G.

I have only played around with SQL Server Express, but I know that views do not
take parameters, stored procedures take parameters, and I do not think stored
procedures are updateable. Probably what you want to do is not use parameters
at all. Create a view, link to the view from Access, and use the view as the
record source of your form. Then you run queries against the view and
processing is extremely fast. Really, you do not do anything differently and
your form works as normal.