List all tables in Database (ADODB)

[Deepthiv]

I have added ActiveX Data Objects reference (ADODB)

when i am trying to use

rs = conn.OpenSchema(adSchemaTables)

error exists - No OpenSchema method..

am i missing any thing can some one please confirm

 

[kulrom]

This should work:

[SIZE=2][COLOR=#0000ff]Dim[/COLOR][/SIZE][SIZE=2] AccessDataTable [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] DataTable
AccessDataTable = oledbcon.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, [/SIZE][SIZE=2][COLOR=#0000ff]New[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#0000ff]Object[/COLOR][/SIZE][SIZE=2]() {[/SIZE][SIZE=2][COLOR=#0000ff]Nothing[/COLOR][/SIZE][SIZE=2], [/SIZE][SIZE=2][COLOR=#0000ff]Nothing[/COLOR][/SIZE][SIZE=2], [/SIZE][SIZE=2][COLOR=#0000ff]Nothing[/COLOR][/SIZE][SIZE=2], "Table1"})[/SIZE]
[SIZE=2]

[/SIZE]

Regards

 

[Deepthiv]

Thanka Kulrom

This worked...