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]

"abcd" <ab**@abcd.com> schrieb

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...

"Armin Zingler" <az*******@freenet.de> wrote in message
news:eh**************@tk2msftngp13.phx.gbl...

"abcd" <ab**@abcd.com> schrieb

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

[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]

"Cor Ligthert [MVP]" <no************@planet.nl> schrieb

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)

:-))

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