hi

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


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