Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Tables
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Tables
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
felix.akinyemi View Drop Down
Groupie
Groupie
Avatar

Joined: 09 December 2004
Location: United States
Status: Offline
Points: 113 		Post Options Post Options   Thanks (0) Thanks(0)   Quote felix.akinyemi Quote  Post ReplyReply Direct Link To This Post Topic: Tables
    Posted: 31 January 2005 at 8:31pm
Just a little help!!
 
Is there a way to list all the tables in an access database on a web page!!
 
Not lost the records, but the actual tables!!
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 31 January 2005 at 9:59pm
The following query should do it for you
Select name from MSysObjects where type=1 and flags=0
Blog | MPG Tracker
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 01 February 2005 at 4:39am
have you set the tables to hidden, if you go to options on the menu, in one of the tabs there is shows hidden itemts/objects.
Back to Top
felix.akinyemi View Drop Down
Groupie
Groupie
Avatar

Joined: 09 December 2004
Location: United States
Status: Offline
Points: 113 		Post Options Post Options   Thanks (0) Thanks(0)   Quote felix.akinyemi Quote  Post ReplyReply Direct Link To This Post Posted: 01 February 2005 at 9:10am
^^ No the tables are not hidden
 
 
Originally posted by michael michael wrote:

The following query should do it for you
Select name from MSysObjects where type=1 and flags=0
how will i write it out... e.g, to list fields, you write rs.Fields("xxx")
 
how do i write out one for tables!!
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 01 February 2005 at 10:14am
rs.Fields("name")
Blog | MPG Tracker
Back to Top
felix.akinyemi View Drop Down
Groupie
Groupie
Avatar

Joined: 09 December 2004
Location: United States
Status: Offline
Points: 113 		Post Options Post Options   Thanks (0) Thanks(0)   Quote felix.akinyemi Quote  Post ReplyReply Direct Link To This Post Posted: 01 February 2005 at 10:29am
Ok, you not quiet getting what i mean... lol...
 
ok, say from from the forum database (access)
 
i want to be able to list all the tables...
 
e.g.
 
  • tblAuthor
  • tblBanList
  • tblBuddyList
  • tblCategory
  • tblConfiguration
  • tblDateTimeFormat

and so on... that what im talking about, i guess i should have explain properly earlier!!
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 01 February 2005 at 10:40am
hes correct do the query as sugested then do #

do while not rs.EOF

response.write (rs("name") & "<br/>")

rs.movenext
loop

resplace rs with the name of the connection you have open
Back to Top
felix.akinyemi View Drop Down
Groupie
Groupie
Avatar

Joined: 09 December 2004
Location: United States
Status: Offline
Points: 113 		Post Options Post Options   Thanks (0) Thanks(0)   Quote felix.akinyemi Quote  Post ReplyReply Direct Link To This Post Posted: 01 February 2005 at 11:25am
ok, from his query what goes in place of name
 
Select name from MSysObjects where type=1 and flags=0
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.