|
 |
asp_databases thread: Listing Queries
Message #1 by "Tony Blackman" <tonyblac@n...> on Tue, 13 Jun 2000 17:00:00 +0100
|
|
Hi!
My current application lists tables and queries from an Access2000 Database
using MSys objects. I would like to list reports as well. Any ideas?
Regards
Tony Blackman
Tel (01404) 46600
Fax (01404) 46600
email tonyblac@n...
Message #2 by "Ken Schaefer" <ken.s@a...> on Thu, 15 Jun 2000 13:01:14 +1000
|
|
Looking in my Access database, I can see several Reports listed in the
MSysObjects table with type = -32764
I don't think this is a definitive answer, but why don't you look in the
MSysObjects Table and see if you can see your reports listed there...
Cheers
Ken
----- Original Message -----
From: "Tony Blackman"
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, June 14, 2000 2:00 AM
Subject: [asp_databases] Listing Queries
> Hi!
>
> My current application lists tables and queries from an Access2000
Database
> using MSys objects. I would like to list reports as well. Any ideas?
>
> Regards
>
> Tony Blackman
> Tel (01404) 46600
> Fax (01404) 46600
> email tonyblac@n...
Message #3 by "Tony Blackman" <tonyblac@n...> on Thu, 15 Jun 2000 09:43:07 +0100
|
|
Ken
You are a winner!
I have to admit I don't understand why type produces tables, type 5 produces
queries and type -32764 produces listing of reports. How can I educate
myself. My wrox bible doesn't seem to cover the situation.
Thanks one again.
Regards
Tony Blackman
Tel (01404) 45982
Fax (01404) 46600
email tonyblac@n...
-----Original Message-----
From: Ken Schaefer
Sent: 15 June 2000 04:01
To: ASP Databases
Subject: [asp_databases] Re: Listing Queries
Looking in my Access database, I can see several Reports listed in the
MSysObjects table with type = -32764
I don't think this is a definitive answer, but why don't you look in the
MSysObjects Table and see if you can see your reports listed there...
Cheers
Ken
Message #4 by "Ken Schaefer" <ken.s@a...> on Thu, 15 Jun 2000 21:32:03 +1000
|
|
Under Tools | Options | View
Check the box that says "View System Objects"
The MSysObjects table becomes visible. Open it up and you will see all the
things you can list (it's just like querying any other table)
Cheers
Ken
----- Original Message -----
From: "Tony Blackman"
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, June 15, 2000 6:43 PM
Subject: [asp_databases] Re: Listing Queries
> Ken
>
> You are a winner!
>
> I have to admit I don't understand why type produces tables, type 5
produces
> queries and type -32764 produces listing of reports. How can I educate
> myself. My wrox bible doesn't seem to cover the situation.
>
> Thanks one again.
>
> Regards
|
|
|
View Cart
