On Fri, 25 Feb 2005, Martin Hodder wrote:

> To test this out I used the DBMS Sql Builder from the tool manager which
> uses ODBC.
> 
> The results came back as expected.

I don't seem to have DBMS Sql Builder, but I tried the following code to 
open the table via ODBC:

Server Link Table "SELECT Name FROM MSysObjects WHERE Type=1;"
Using "DSN=MS Access Database;DBQ=c:\tmp\sample.mdb;UID=ADMIN"
toolkit "ODBC"
Into "Test" File "C:\My Documents\Test.TAB"

And I still get a "read permission" error on that MSysObjects table.  
This works with the normal tables, though. Do you have the code that your
DBMS SQL Builder generated?


---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 15432

Reply via email to