connection.OpenSchema

[abcd]

I have a small VB code which retrives the table names from the access DSN.

my code is something like this

Set objRs = objConn.OpenSchema(adSchemaTables)

If objRs("TABLE_TYPE") = "TABLE" or objRs("TABLE_TYPE") = "TABLE" Then
'do something
end if

I want to retrieve all the queries from theaccess DSN, whats the proper
schemaEnum for this...

thanks in advance

 

[Armin Zingler]

I have a small VB code which retrives the table names from the
access DSN.

my code is something like this

Set objRs = objConn.OpenSchema(adSchemaTables)

If objRs("TABLE_TYPE") = "TABLE" or objRs("TABLE_TYPE") = "TABLE"
Then 'do something
end if

I want to retrieve all the queries from theaccess DSN, whats the
proper schemaEnum for this...

Have a look at the language independent ADO.Net group:
microsoft.public.dotnet.framework.adonet


This is a VB.Net group. As you wrote "Set", you're probably using VB6. VB6
groups can be found @ microsoft.public.vb.*


Armin

 

[abcd]

ooops accidently I posted here ...my apology...

Have a look at the language independent ADO.Net group:
microsoft.public.dotnet.framework.adonet


This is a VB.Net group. As you wrote "Set", you're probably using VB6. VB6
groups can be found @ microsoft.public.vb.*


Armin

 

[Cor Ligthert [MVP]]

Armin,

Have a look at the language independent ADO.Net group:
microsoft.public.dotnet.framework.adonet

Are you sure of that, I have the idea that it is not ADONET however ADO

probably
microsoft.public.dotnet.languages.vb.data

is than in my opinion a better newsgroup
(Most questions are answered in that newsgroup, this message is of course as
well for the OP)

)

Cor

 

[Armin Zingler]

Armin,
Are you sure of that, I have the idea that it is not ADONET however
ADO

probably
microsoft.public.dotnet.languages.vb.data

is than in my opinion a better newsgroup
(Most questions are answered in that newsgroup, this message is of
course as well for the OP)

)

"As you wrote "Set", you're probably using VB6. VB6 groups can be found @
microsoft.public.vb.*"


Armin