parametre and views

[Danny Nielsen]

Hi
How do I use parameters in views? (I would really like an example). I need
to be able to call a view using Access project. I know its possible (and the
best) to use stored procedure to do this, but at the time I haven't
installed updates of Access2000 and therefore Access seems not to be able to
find stored procedures.
Therefore, this problem only concerns the use of views.


Many thanks in regards

Danny Nielsen

 

[J. Clay]

Views cannot use parameters or the ORDER BY clause. If you need parameters,
you need to use stored procedures.

J. Clay

 

[Danny Nielsen]

Thats what I thought.

Thanks for your reply

Danny Nielsen