MSysObjects no read permission

[murrayja]

I have an access 97 data base constructed from an oracle schema via a C# program. The DataBase looks fine and I want to write a C# program to copy it to a MySql database. When I "select table_name from MSysObjects" access throws an exception "42000 cannot be read, no read permission".

How do I get read permission?
I can't see MSysObjects with the access gui.

thanks
jim murray

 

[PHV]

Why not simply use the TableDefs collection ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[murrayja]

One reason would be that I have never heard of it.
Another might be that I am not using VBA and that sounds like it is not accessible via SELECT.
Thanks.

 

[Remou]

How about ADO schemas?

Dim RS As New ADODB.Recordset
Dim cn As New ADODB.Connection
Dim strText As String



    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Docs\LTD.mdb;"
    Set RS = cn.OpenSchema(adSchemaTables)
    
    Do While Not RS.EOF
        Debug.Print RS!Table_Name
        RS.MoveNext
    Loop

http://lessthandot.com