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

"abcd" <(E-Mail Removed)> 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

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

"Armin Zingler" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "abcd" <(E-Mail Removed)> 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

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

"Cor Ligthert [MVP]" <(E-Mail Removed)> 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