Re: [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

"man-wai chang" <toylet.toylet@xxxxxxxxx> skrev i meddelandet
news:eWWA7YH4FHA.3628@xxxxxxxxxxxxxxxxxxxxxxx
> 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


.



Relevant Pages

  • Re: [ot] access
    ... > SQLTABLES (conn, 'TABLE', crsTables') ... Prev by Date: ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Proper Database Connection Cleanup
    ... Public Sub ConnectToDB2(byref XCmd, byref YRS, byRef Conn) ... Public Sub CloseDBCon ... I am new to using their database and I do connect two or three ...
    (microsoft.public.scripting.vbscript)
  • Re: Proper Database Connection Cleanup
    ... but I think two of them have a database query in them. ... Public Sub ConnectToDB2(byref XCmd, byref YRS, byRef Conn) ... Set ObjRS = ObjCmd.Execute ... from DB connections in my code or from something else? ...
    (microsoft.public.scripting.vbscript)
  • Re: How to get the data from a huge table efficiently?
    ... only display/ship the results on the client-side. ... // SQL Server 2000 Database ... Connection conn = null; ... CallableStatement qstmt = conn.prepareCall(sql, ...
    (comp.lang.java.databases)
  • [0day Remote Command Execution] VigileCMS <= 1.8 Stealth
    ... The first vulnerability is in index.php that verifies the login without sql database verifying the existence of files with the structure Nick.HashMD5Password.php in a dir "db". ... A lot of other Vulnerabilities have been found in this platform, but their functionality depends by the configuration OFF of MAGIC QUOTES or other uses of vulnerabilities I explained, so they were not published. ... conn = httplib.HTTPConnection ... response = conn.getresponse ...
    (Bugtraq)