Re: How to close catalog?

From: Victor Koch ("Victor)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 13:37:28 -0300

Hi Sergey try this

   Dim cnn As New Connection
   Dim cat As New Catalog
   Dim tbl As Table

   cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
      "Data Source= c:\Program Files\Microsoft Office\" & _
      "Office\Samples\Northwind.mdb;"
   Set cat.ActiveConnection = cnn
   Set tbl = cat.Tables(0)
   Debug.Print tbl.Type ' Cache tbl.Type info
   Set cat.ActiveConnection = Nothing '<--- Close catalog 

--
 Víctor Koch From Argentina.
"Sergey" <anonymous@discussions.microsoft.com> escribió en el mensaje
news:B7681D9A-091D-4B30-AC09-83AE09B4ABCB@microsoft.com...
> Hello!
> Problem with ADOX
> Do you know, how to close Catalog (close the connection)?
> Connection was created using Create Method.
> If I use just ActiveConnection Property (to connect to already existing
base), it's easy to close connection...
>
> Thanks
>

Relevant Pages