Table ODBC MSAccess

[VB_Lazarus]

Hello,
Is there any way to read all the tables from a MSAccess DB with an ODBC Connection?

I tried the SQL with select MSysObjects. But I got the message I have no access to do this.

Thanks.

best regards

[af0815]

IMHO is there a Problem with ODBC, it can not access with the rigths to get information from MSysObjects. I got a lot of samples wirh google but no realy workable soulution, except you manipulate the rights for the MSysObjwcts table, but this is not possible with ODBC

[LacaK]

If you want list of tables you can use: TSQLConnection.GetTableNames ?

[wp]

I picked up LacaK's idea and applied it to one of my default samples - see attached demo. Yes, it is working. Simply call SQLConnection.GetTablenames and provide a TStrings parameter, in my example the items of the listbox at the the left to populate it with the table names in the database. Click on a tablename to open the corresponding query.