Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    3

    Smile Unanswered: Using ODBC OR ADODB to use a built in ACCESS Query

    Hi,

    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?

    Thanks,

    Ron

  2. #2
    Join Date
    Feb 2004
    Posts
    3

    Eureka

    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!

    Hope this helps someone.

    Now how to pass paramater to my queries.

    TTFN

    Ron

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •