name_space
name_space

Reputation: 47

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.

Upvotes: 3

Views: 6875

Answers (1)

Cheran Shunmugavel
Cheran Shunmugavel

Reputation: 8459

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.

Upvotes: 3

Related Questions