Append Method (Views)
Creates a new View object and appends it to the Views collection.
Syntax
Views.Append Name, Command
Parameters
Name A String value that specifies the name of the view to create.
Command An ADO Command object that represents the view to create.
Remarks
Creates a new view in the data source with the name and attributes specified in the Command object.
If the command text that the user specifies represents a procedure rather than a view, the behavior is dependent upon the provider. Append will fail if the provider does not support persisting commands.
Note: When using the OLE DB Provider for Microsoft Jet, the Views collection Append method will allow you to specify a Procedure rather than a View in the Command parameter. The Procedure will be added to the data source and will be added to the Views collection. After the Append, if the Procedures and Views collections are refreshed, the Procedure will no longer be in the Views collection and will appear in the Procedures collection.