Home > ASP Development > how to get table names from mdb for menu

how to get table names from mdb for menu

HI

i want to make a drop down menu with the names of the tables in the mdb.

how do i get this right? do i use a sql statement? i cannot

find a sql statement with the command for this.

thanks

Shem

Guest

Hi Shem,

try this query:

Code:



sql = "SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>""~"") AND (Left$([Name],4) <> ""Msys"") AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name"

rs.Open sql, conn



while not rs.EOF

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

	rs.moveNext

wend

hope this helps

Was this answer helpful ? Yes No

Guest

can you explain wots going on in that sql, just so i understand what it that i'm doing, if ya don't mind.

ps. saturday dawn patrol, seems the SE is gona pick up early in the day

Was this answer helpful ? Yes No

Guest

the MsysObjects is a table that holds everything from you access, forms/ tables/ reports

so it selects everything from that table, the criteria(WHERE CLAUSE) is to ensure that

only user defined tables come out and not the system objects too.

Hope that makes it a bit clearer