On Fri, 25 Feb 2005, Martin Hodder wrote:
> If you use ODBC to open the database and then send this statement
> "select name, type from MSysObjects where type = 1"
> This return all the tables in the database (including the system tables.
Ah! This is very close to what I want. So I thought I'd try it directly
(without ODBC) using the following code:
Dim sDB As String
Close All
sDB = ApplicationDirectory$()+"Sample.mdb"
Register Table sDB Type "Access" Table "MSysObjects"
Into ApplicationDirectory$()+"test.tab"
Open Table ApplicationDirectory$()+"test.tab" As TEST
Select Name From TEST where Type = 1 into TABS
Browse * from TABS
But it didn't work. I get an error that there is no read permission on
MSysObjects. If I try this with a normal table, this works fine. If I open
the database in Access, I can select data from MSysObjects. So it looks
like the Access user can list hidden table data, but an outside MapInfo
connection cannot.
Will this restriction occur with an ODBC connection too?
- Bill Thoen
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 15428
