How to list tables in access database?

[mwiertz]

Hi,

I'm trying to retrieve a list of tables from an MS Access mdb database file from Python using JayDeBeApi combined with UCanAccess. Querying the database works fine, though I cannot find out how top list all tables. I've been googling and trying for days now, but was not able to find a solution.

Anyone can help?

Thanks, best,
Max

[deweydb]

Did you ever figure this out? stuck on the same thing.

[mwiertz]

Unfortunately, no. Ended up working around it by converting the databases to sqlite... Bit drastic to do over and over again, but couldn't find another solution.

[deweydb]

I figured it out:
select * from information_schema.tables
It seems ucanaccess actually "copies" the original .mdb to an hsqldb one at connection time.