How to create views in Access 2007?

Now in SQL views are tables which can be used for data abstraction (showing specific data to required users). Also you can edit data and insert data into the original table through views. What I want is an equivalent of this in access. I have been able to create a view table in access but the problem is that开发者_运维问答 it cannot be used to update the record set.

In Jet databases, the equivalent of a view is a saved query. You should be able to update the base tables through the query, provided that the query obeys certain rules. These rules are documented in the Access 2007 help. If you provide your view definition and some details about the base table(s), we can give some specific advice about why the query isn't updatable.