Unanswered: Using ODBC OR ADODB to use a built in ACCESS Query
I'm trying to find a way to use queries that are already in an ACCESS database, instead of doing the SQL in the php. Is there a way to access the ACCESS queries using ODBC or ADODB functions? Is there some query object or something?
After a little screwing around i used ODBC_COLUMNS() to see every thing that the database had to offer. I noticed My access queries were listed as tables in the database. Problem solved.
Just use a sql statement like this
"Select * from Queryname"
And wallah you got the whole query result sent to you. Sweet!