Views Refresh Method Example (VB)

Microsoft ActiveX Data Objects (ADO)

Views Refresh Method Example (VB)

The following code shows how to refresh the Views collection of a Catalog. This is required before View objects from the Catalog can be accessed.

Sub ProcedureRefresh()

    Dim cat As New ADOX.Catalog

    ' Open the Catalog
    cat.ActiveConnection = _ 
        "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=c:\Program Files\" & _
        "Microsoft Office\Office\Samples\Northwind.mdb;"

    ' Refresh the Procedures collection
    cat.Views.Refresh

End Sub