View can be created in Access 2000? [closed]

开发者_开发知识库 It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 10 years ago.

In Access 2000, can we create views?

---

Yes.

SQL Server Views are called Queries in Access.

---

The usual way in Access to use code to create a saved query is to use DAO to create a saved QueryDef. Something like this:

  Dim db As DAO.Database
  Dim qdf As DAO.QueryDef

  Set db = CurrentDb
  Set qdf = db.CreateQueryDef("MyQuery", "SELECT * FROM MyTable;")

  Set qdf = Nothing
  Set db = Nothing

That will work in all versions of Access with a DAO reference.

---

"The CREATE VIEW and DROP VIEW statements can be executed only through the Jet OLE DB provider and ADO...". Taken from: http://msdn.microsoft.com/en-us/library/aa139977(v=office.10).aspx#acadvsql_views