I need to create a view in access with parameter

Hello guys,

I need to create a view in access with parameters, I am trying to do this with Tadoquery but I am having an error that informs that parameter in view is not
possible. In access I have view with parameters, so it is perfectly possible.

How to do that?
LVL 1
hidrauAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mikelittlewoodConnect With a Mentor Commented:
I think my problem is why you would want to have a view with parameters anyway.
Its not quicker than using a standard query to the database as the view wouldnt be prepared with undefined SQL anyway.
Wouldnt you be better off just doing a query to the originating tables, or creating a view without the parameter then query the view using a standard query?
0
 
mikelittlewoodCommented:
I didn't think that this was possible.
As far as I always knew, views don't expect parameters.
0
 
hidrauAuthor Commented:
But I have a view with parameter in access and when I call it in my tadoquery, I open the parameters and it is there
0
 
hidrauAuthor Commented:
Ok, no problem now

I solved the things for another way without parameters.

to drop a view this line is correct:

drop table table1

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.