View object (ADOX)

Applies to: Access 2013, Office 2013

Represents a filtered set of records or a virtual table. When used in conjunction with the ADO Command object, the View object can be used for adding, deleting, or modifying views.

Remarks

A view is a virtual table, created from other database tables or views. The View object allows you to create a view without having to know or use the provider's "CREATE VIEW" syntax.

With the properties of a View object, you can:

  • Identify the view with the Name property.

  • Specify the ADO Command object that can be used to add, delete, or modify views with the Command property.

  • Return date information with the DateCreated and DateModified properties.