Help: how to create a View.

[Fred Marghem]

CREATE VIEW is valid for SQL Systems such as SQL Server or Oracle.

CREATE VIEW does not work in Access ; But you might either use SELECT
queries to do the job, or build your own SELECT SQL statements in code to do
it

/Fred

Andrea Belisari wrote in message <35FEC84A...@flashnet.it>...
Hi all,
I'm trying to implement a relational database model using Access.
I want some fields of a table hidden for some users and visible to
others, but I can't use the SQL instruction CREATE VIEW. Is it possible I
can't define a View in Access ?
Thanks for your help,
Andrea