List Access database tables

[Kevin Ingram]

I am using ASP and a MS-Access database. Can read and write to tables fine,
but now I have a need to list all the tables in a given database.

I am using IIS5 and Visual InterDev 6.0, and ODBC System DSN.

So far, every attempt I have made returns this error:

ADODB.Connection error '800a0cb3'

Object or provider is not capable of performing requested operation.
/TESTDB.asp, line 74

Is there something I am doing wrong, or is MS-Access unable to list the
tables in ASP?

I can post the code I've been trying if that will help.

[Ray at]

Posting the relevant snippet of code would certainly be helpful, as we
cannot see what operation was requested.

Ray at work

"Kevin Ingram" <tcr@myrealbox.com> wrote in message
news:btk9le06cf@enews2.newsguy.com...

> I am using ASP and a MS-Access database. Can read and write to tables

fine,

> but now I have a need to list all the tables in a given database.
>
> I am using IIS5 and Visual InterDev 6.0, and ODBC System DSN.
>
> So far, every attempt I have made returns this error:
>
> ADODB.Connection error '800a0cb3'
>
> Object or provider is not capable of performing requested operation.
> /TESTDB.asp, line 74
>
> Is there something I am doing wrong, or is MS-Access unable to list the
> tables in ASP?
>
> I can post the code I've been trying if that will help.
>
>
>
>
>
>
>
>
>
>

[Kevin Ingram]

Here is the code:

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "DSN=MYDATA"
objConn.Open
Set objRS = objConn.OpenSchema(adSchemaTables)

The last line produces this error:

ADODB.Connection error '800a0cb3'
Object or provider is not capable of performing requested operation.
/TESTDB.asp, line 74


"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:O3gKn%23h1DHA.832@TK2MSFTNGP09.phx.gbl...

> Posting the relevant snippet of code would certainly be helpful, as we
> cannot see what operation was requested.
>
> Ray at work
>
> "Kevin Ingram" <tcr@myrealbox.com> wrote in message
> news:btk9le06cf@enews2.newsguy.com...

> > I am using ASP and a MS-Access database. Can read and write to tables

> fine,

> > but now I have a need to list all the tables in a given database.
> >
> > I am using IIS5 and Visual InterDev 6.0, and ODBC System DSN.
> >
> > So far, every attempt I have made returns this error:
> >
> > ADODB.Connection error '800a0cb3'
> >
> > Object or provider is not capable of performing requested operation.
> > /TESTDB.asp, line 74
> >
> > Is there something I am doing wrong, or is MS-Access unable to list the
> > tables in ASP?
> >
> > I can post the code I've been trying if that will help.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >

>
>

[Ray at]

Did you define your adSchemaTables constant anywhere? (&h14)

Ray at work


"Kevin Ingram" <tcr@myrealbox.com> wrote in message
news:btkcf10a6b@enews2.newsguy.com...

> Here is the code:
>
> Set objConn = Server.CreateObject("ADODB.Connection")
> objConn.ConnectionString = "DSN=MYDATA"
> objConn.Open
> Set objRS = objConn.OpenSchema(adSchemaTables)
>
> The last line produces this error:
>
> ADODB.Connection error '800a0cb3'
> Object or provider is not capable of performing requested operation.
> /TESTDB.asp, line 74
>
>
> "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
> news:O3gKn%23h1DHA.832@TK2MSFTNGP09.phx.gbl...

> > Posting the relevant snippet of code would certainly be helpful, as we
> > cannot see what operation was requested.
> >
> > Ray at work
> >
> > "Kevin Ingram" <tcr@myrealbox.com> wrote in message
> > news:btk9le06cf@enews2.newsguy.com...

> > > I am using ASP and a MS-Access database. Can read and write to tables

> > fine,

> > > but now I have a need to list all the tables in a given database.
> > >
> > > I am using IIS5 and Visual InterDev 6.0, and ODBC System DSN.
> > >
> > > So far, every attempt I have made returns this error:
> > >
> > > ADODB.Connection error '800a0cb3'
> > >
> > > Object or provider is not capable of performing requested operation.
> > > /TESTDB.asp, line 74
> > >
> > > Is there something I am doing wrong, or is MS-Access unable to list

the

> > > tables in ASP?
> > >
> > > I can post the code I've been trying if that will help.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >

> >
> >

>
>

[Kevin Ingram]

Apparently I am missing something here, how do I define the constant other
than: dim adSchemaTables?

Thanks!

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:uInSdki1DHA.2060@TK2MSFTNGP10.phx.gbl...

> Did you define your adSchemaTables constant anywhere? (&h14)
>
> Ray at work
>
>
> "Kevin Ingram" <tcr@myrealbox.com> wrote in message
> news:btkcf10a6b@enews2.newsguy.com...

> > Here is the code:
> >
> > Set objConn = Server.CreateObject("ADODB.Connection")
> > objConn.ConnectionString = "DSN=MYDATA"
> > objConn.Open
> > Set objRS = objConn.OpenSchema(adSchemaTables)
> >
> > The last line produces this error:
> >
> > ADODB.Connection error '800a0cb3'
> > Object or provider is not capable of performing requested operation.
> > /TESTDB.asp, line 74
> >
> >
> > "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
> > news:O3gKn%23h1DHA.832@TK2MSFTNGP09.phx.gbl...

> > > Posting the relevant snippet of code would certainly be helpful, as we
> > > cannot see what operation was requested.
> > >
> > > Ray at work
> > >
> > > "Kevin Ingram" <tcr@myrealbox.com> wrote in message
> > > news:btk9le06cf@enews2.newsguy.com...
> > > > I am using ASP and a MS-Access database. Can read and write to

tables

> > > fine,
> > > > but now I have a need to list all the tables in a given database.
> > > >
> > > > I am using IIS5 and Visual InterDev 6.0, and ODBC System DSN.
> > > >
> > > > So far, every attempt I have made returns this error:
> > > >
> > > > ADODB.Connection error '800a0cb3'
> > > >
> > > > Object or provider is not capable of performing requested operation.
> > > > /TESTDB.asp, line 74
> > > >
> > > > Is there something I am doing wrong, or is MS-Access unable to list

> the

> > > > tables in ASP?
> > > >
> > > > I can post the code I've been trying if that will help.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >

> >
> >

>
>

[Ray at]

Const adSchemaTables = 20
or
Const adSchemaTables = &h14
or
Just use 20 in place of the named constant.

Ray at work

"Kevin Ingram" <tcr@myrealbox.com> wrote in message
news:btkkaa0q7l@enews2.newsguy.com...

> Apparently I am missing something here, how do I define the constant other
> than: dim adSchemaTables?
>
> Thanks!
>
> "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
> news:uInSdki1DHA.2060@TK2MSFTNGP10.phx.gbl...

> > Did you define your adSchemaTables constant anywhere? (&h14)
> >
> > Ray at work
> >
> >
> > "Kevin Ingram" <tcr@myrealbox.com> wrote in message
> > news:btkcf10a6b@enews2.newsguy.com...

> > > Here is the code:
> > >
> > > Set objConn = Server.CreateObject("ADODB.Connection")
> > > objConn.ConnectionString = "DSN=MYDATA"
> > > objConn.Open
> > > Set objRS = objConn.OpenSchema(adSchemaTables)
> > >
> > > The last line produces this error:
> > >
> > > ADODB.Connection error '800a0cb3'
> > > Object or provider is not capable of performing requested operation.
> > > /TESTDB.asp, line 74
> > >
> > >
> > > "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in

message

> > > news:O3gKn%23h1DHA.832@TK2MSFTNGP09.phx.gbl...
> > > > Posting the relevant snippet of code would certainly be helpful, as

we

> > > > cannot see what operation was requested.
> > > >
> > > > Ray at work
> > > >
> > > > "Kevin Ingram" <tcr@myrealbox.com> wrote in message
> > > > news:btk9le06cf@enews2.newsguy.com...
> > > > > I am using ASP and a MS-Access database. Can read and write to

> tables

> > > > fine,
> > > > > but now I have a need to list all the tables in a given database.
> > > > >
> > > > > I am using IIS5 and Visual InterDev 6.0, and ODBC System DSN.
> > > > >
> > > > > So far, every attempt I have made returns this error:
> > > > >
> > > > > ADODB.Connection error '800a0cb3'
> > > > >
> > > > > Object or provider is not capable of performing requested

operation.

> > > > > /TESTDB.asp, line 74
> > > > >
> > > > > Is there something I am doing wrong, or is MS-Access unable to

list

> > the

> > > > > tables in ASP?
> > > > >
> > > > > I can post the code I've been trying if that will help.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >

> >
> >

>
>

[Aaron Bertrand [MVP]]

Plenty of other approaches.
[url]http://www.aspfaq.com/2178[/url]

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]

[Kevin Ingram]

Wow, that's perfect, thanks!

Man, I searched and searched but just could not stumble on this information,
have it saved as a favorite now.

Thanks again!

"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:%23UocRvl1DHA.2412@TK2MSFTNGP10.phx.gbl...

> Plenty of other approaches.
> [url]http://www.aspfaq.com/2178[/url]
>
> --
> Aaron Bertrand
> SQL Server MVP
> [url]http://www.aspfaq.com/[/url]
>
>