<p>I am using following PHP code to connect to MS Access database:</p>

<pre><code>$odb_conn = new COM("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". $db_path.";";
$odb_conn-&gt;open($connstr);
</code></pre>

<p>How can I retrieve database catalog/metadata from the mdb file?</p>

<p><strong>FOUND THE SOLUTION</strong></p>

<pre><code>$rs_meta = $odb_conn-&gt;OpenSchema(20, array(Null, Null, Null, "TABLE"));
</code></pre>

The
```
MSysObjects
```
table can be used to query metadata in Access:
```
```
SELECT NAME
FROM MSysObjects
WHERE Type In (1,4,6) AND Left([Name],4)<>"MSYS"
```
```