Discover names of tables contained in Access database

Sweetness woot! I love you Terri! 


Aaron

________________________________

From: Terri Morton [mailto:terri.mortongmail.com] 
Sent: Friday, 29 September 2006 10:51
To: aspnet-databasesaspadvice.com
Subject: [aspnet-databases] Re: Discover names of tables
contained in Access
database


Hi Aaron, I had better luck with Google .  I
tried this search term:

"Access database" query list tables


On the first page of hits was this link: How do I get a list
of Access
tables and their row counts?
<http://databases.aspfaq.com/database/
how-do-i-get-a-list-of-access-tables-a
nd-their-row-counts.html> 

Googling further for MSysObjects turned up this link, which
was more
helpful: Queries: Return database object names
<ht
tp://www.mvps.org/access/queries/qry0002.htm> 

This query will do it:


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

Regards,
Terri Morton
MVP - ASP/ASP.NET




Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com
Need XML Advice? http://xmladvice.com

   I don't get it... The behavior of 'ksu' is entirely
different from 
'su'. It doesn't check whether user is listed in wheel group
- it just 
lets user in if he knows password. And when there's no root
password 
(sometimes it's much easier to add to wheel group all who is
responsible 
while all other are left out) it just lets anyone in
unconditionally. It 
seems that ordinary su works through pam, while ksu
doesn't... What am I 
missing?

-- 
[WBR], Arcade.
_______________________________________________
freebsd-questionsfreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-que
stions
To unsubscribe, send any mail to
"freebsd-questions-unsubscribefreebsd.org"