connection.Open Schema

[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.OpenSch ema(adSchemaTab les)

If objRs("TABLE_TY PE") = "TABLE" or objRs("TABLE_TY PE") = "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.co m> 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.OpenSch ema(adSchemaTab les)

If objRs("TABLE_TY PE") = "TABLE" or objRs("TABLE_TY PE") = "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.publi c.dotnet.framew ork.adonet
This is a VB.Net group. As you wrote "Set", you're probably using VB6. VB6
groups can be found @ microsoft.publi c.vb.*
Armin

[abcd]

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

"Armin Zingler" <az*******@free net.de> wrote in message
news:eh******** ******@tk2msftn gp13.phx.gbl...

"abcd" <ab**@abcd.co m> 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.OpenSch ema(adSchemaTab les)

If objRs("TABLE_TY PE") = "TABLE" or objRs("TABLE_TY PE") = "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.publi c.dotnet.framew ork.adonet
This is a VB.Net group. As you wrote "Set", you're probably using VB6. VB6
groups can be found @ microsoft.publi c.vb.*
Armin

[Cor Ligthert [MVP]]

Armin,

Have a look at the language independent ADO.Net group:
microsoft.publi c.dotnet.framew ork.adonet

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

probably
microsoft.publi c.dotnet.langua ges.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.publi c.dotnet.framew ork.adonet

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

probably
microsoft.publi c.dotnet.langua ges.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.publi c.vb.*"
Armin