Table ODBC MSAccess
lazarus / 16-Databases

----------------------------------------------------------------------
VB_Lazarus · 2020-04-02 15:08

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 · 2020-04-02 17:26

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 · 2020-05-11 07:16

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

----------------------------------------------------------------------
wp · 2020-05-11 11:27

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.