create view in access

[Anon]

Hi !

It is possible create a view in access using a sql query like :

create view view1 as select * from tabla ?

How can I do ?

Thanks!

[Anon]

Did you ever find a solution/answer to this question. I have a similar need.

Thanks,

Pat Kane

[Anon]

Hi!

Views are not supported in Access. To create a view, use the Queries tab and make a new query. This is as close as you can get to the View functionality.
Do you need to achieve anything special with views?

Best,
Stas