how to get db tables?

[Ciary]

hi all, seems like i'm stuck with another problem. in my website i'm using a access database. to do this, i used odbc with a connection string. what i want to do now is print a list of all tables in this connection. does anyone know how this can be done?


the code below is what i have so far. it returns the fields of 1 table:

db_connection = new COM("ADODB.Connection", NULL, 1251);
$db_connstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=".$path."Persist Security Info=False;";
 
$db_connection->open($db_connstr);
$query = "SELECT * FROM goo";
$rs = $db_connection->execute($query);
$rs_fld0 = $rs->Fields(0);
$rs_fld1 = $rs->Fields(1);
$rs_fld2 = $rs->Fields(2);
 
$fields = array();
for( $x = 0; $x < $rs->Fields->Count; $x++ ){
    $fields[] = $rs->Fields[$x]->Name;
}
 
 
$rs->Close();
$db_connection->Close(); 
?>

[Markus]

This thread may be of some help to you.

I'm not experienced with ODBC, though.

Let me know how you get on.

Mark.

[Ciary]

not really :(
but i found another way.
now, i'm reading the system tables of access. i dont know if you're familiar with access but normally on the left side of the screen there is a navigation pane. the contents of this pane are stored in the table: MSysNavPaneObjectIDs. if you read this one and filter its contents, you get your own tables. you need to filter on type (1 for tables) and filter the system tables (those are always the same so i've put them in an array for those who want to do the same.

$notMyTables = array(MSysDb, MSysObjects, MSysACEs, MSysQueries, MSysRelationships, MSysComplexColumns, MSysComplexType_UnsignedByte, MSysComplexType_Short, MSysComplexType_Long, MSysComplexType_IEEESingle, MSysComplexType_IEEEDouble, MSysComplexType_GUID, MSysComplexType_Decimal, MSysComplexType_Text, MSysComplexType_Attachment, MSysAccessStorage, MSysAccessXML, MSysIMEXColumns, MSysIMEXSpecs, MSysNavPaneGroupCategories, MSysNavPaneGroups, MSysNavPaneGroupToObjects, MSysNavPaneObjectIDs);

tnx anyway Marcus

[Ciary]

one more thing (for future users), mdb is slightly different then accdb. first you need to add "MSysAccessObjects, " to your array.

second, you need to change the permissions of the MSysNavPaneObjectIDs table. it hasn't any which will make it unable to be read outside access.

if anyone needs the full code, just ask.