Create VIEWS for access Tables

[Satheeshkumar N]

Hi Pals,
Is it possible to create VIEWS for access Tables....
If its possible... How its pls ?

 

[namliam]

Simply use a query, different name, same functionality, same capebility.... (more or less)

Regards

 

[Satheeshkumar N]

Thanks - namliam....

if both having the same ... functionality...... its no use....of going for...

Thanks - namliam

 

[The_Doc_Man]

A query in Access is a view in other DBs. At least, it is, to the limit of whatever Access can do with queries.

If you were looking for ways to control visibility of data by column or row, a query can do that.

If you were looking for ways to control security, views can have different security from the underlying table and can be individually set for noupdate, noinsert, nodelete, etc.

You sound disappointed. Did you want some other behavior?