How to show all tables of Microsoft Access PDO Object?

Question

$tdb = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=$sdltdbsavedfilename; Uid=; Pwd=;");
$sql = 'SHOW TABLES';
$tdbresult = $tdb->query($sql);
var_dump($tdbresult);

Gives: Fatal error: Uncaught PDOException: SQLSTATE [42000] : Syntax error or access violation: [Microsoft] [ODBC Microsoft Access Driver] SQL statement is not correct. Use 'DELETE' 'INSERT', 'PROCEDURE', 'SELECT' OR 'UPDATE'. (SQLPrepare [0] at ext\pdo_odbc\odbc_driver.c:203)

What is the right way?

score 0 · Answer 1 · answered Jul 15 '22 at 11:09

0

Try query the system table:

$sql = 'Select Name From MSysObjects Where Flags = 0 And Type = 1';

answered Jul 15 '22 at 11:09

Gustav

53,498
7
29
55

Unfortunately that gives: no reading rights for MSysObjects. Cannot read records. – Loek van Kooten Jul 15 '22 at 12:14
1

You may have to be user _Admin_: [Record cannot be read; no read permission on 'MSysObjects'](https://stackoverflow.com/a/14669641/3527297). – Gustav Jul 15 '22 at 12:29
The question is then: how do I become Admin from PHP? – Loek van Kooten Jul 15 '22 at 12:35
Just claim that you are. _Admin_ is the default (and for .accdb the only) user. – Gustav Jul 15 '22 at 12:47
I'm afraid I don't know how to claim that from PHP. – Loek van Kooten Jul 15 '22 at 13:12
It's the UID, I guess. But I know zero about pdo. – Gustav Jul 15 '22 at 13:14

score 0 · Answer 2 · answered Jul 15 '22 at 13:55

0

In the end I went for this solution instead:

Check if a database table exists using PHP/PDO

So instead of searching all tables, I just try one and check whether it exists before proceeding.

answered Jul 15 '22 at 13:55

Loek van Kooten

103
1
7

How to show all tables of Microsoft Access PDO Object?

2 Answers2