Hi Bill, To test this out I used the DBMS Sql Builder from the tool manager which uses ODBC.
The results came back as expected. Let me know if you can't get it to work. Regards Martin -----Original Message----- From: Bill Thoen [mailto:[EMAIL PROTECTED] Sent: 25 February 2005 15:23 To: Martin Hodder Cc: [email protected] Subject: RE: MI-L Opening Tables from Access with MapBasic 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 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15429
