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
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
any pointers gratefully recieved
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
any pointers gratefully recieved