list of connections in an Access db

Darth Vodka

Registered User.
Local time
Today, 00:58
Joined
Sep 25, 2007
Messages
344
hi

i know how to check the connections on an Access db in VBA

Code:
Dim rs          As ADODB.Recordset
Set rs = cn.OpenSchema(adSchemaProviderSpecific, _
    , "{947bb102-5d43-11d1-bdbf-00c04fb92675}")

then rattle off the recordset

what i want is this in vb.net... and i'm struggling, can anyone help?

obviously it's System.Data.OleDb and OleDbConnection

but i can't find the connection collection... i thought it might be in connection.GetSchema, but the list of schemas

MetaDataCollections
DataSourceInformation
DataTypes
restrictions
ReservedWords
Columns
Indexes
Procedures
Tables
Views

doesn't seem to be much use, unless i'm missing something :confused::confused:

any pointers gratefully recieved
 

Users who are viewing this thread

Back
Top Bottom