[ot] access  
Author Message
hkhan





PostPosted: Fri Nov 04 06:06:19 CST 2005 Top

Exchange Servers >> [ot] access

After I opened an access MDB, what is the SQL command to list all

1. database
2. table

names in the database?

--
.~. Might, Courage, Vision. http://www.hide-link.com/
/ v \
/( _ )\ (Ubuntu) Linux 2.6.14
^ ^ 20:57:01 up 4 days 22:43 load average: 1.09 1.16 1.15

Exchange Server4  
 
 
man-wai





PostPosted: Fri Nov 04 06:06:19 CST 2005 Top

Exchange Servers >> [ot] access
> After I opened an access MDB, what is the SQL command to list all
>
> 1. database
> 2. table
>
> names in the database?
>
it's "select * from msysobjects", but what is the sa's UID in access?
"admin"? Is the password the same as the database-level password?
--
.~. Might, Courage, Vision. http://www.linux-sxs.org
/ v \
/( _ )\ (Ubuntu) Linux 2.6.14
^ ^ 20:05:01 up 5 days 21:51 load average: 1.11 1.15 1.17
 
 
Anders





PostPosted: Mon Nov 07 22:45:34 CST 2005 Top

Exchange Servers >> [ot] access If you are using an ODBC connection
SQLTABLES ( conn)
BROWSE
or
SQLTABLES (conn, 'TABLE', crsTables')
I don't think there's a way to get Access to return the path and names of
all the MDB files scattered on you machine or server.
-Anders



> After I opened an access MDB, what is the SQL command to list all
>
> 1. database
> 2. table
>
> names in the database?
>
> --
> .~. Might, Courage, Vision. http://www.linux-sxs.org
> / v \
> /( _ )\ (Ubuntu) Linux 2.6.14
> ^ ^ 20:57:01 up 4 days 22:43 load average: 1.09 1.16 1.15


 
 
man-wai





PostPosted: Mon Nov 07 21:28:15 CST 2005 Top

Exchange Servers >> [ot] access > SQLTABLES (conn, 'TABLE', crsTables')

Thanks. that did it.

--
.~. Might, Courage, Vision. http://www.linux-sxs.org
/ v \
/( _ )\ (Fedora Core 4) Linux 2.6.13-1.1532_FC4
^ ^ 11:27:01 up 1 day 2:11 load average: 0.06 0.03 0.00