How to read/modify the Access Queries collection?

From: Igor (Ivanov)
Date: 12/19/04

  • Next message: Brian Bushay TeamB: "Re: Refresh TADODataSet within OnPostError?" 
    Date: 18 Dec 2004 17:32:30 -0800

    Is there a way to read and update using ADO the Queries collection in
    an MDB file, including the SQL property of the queries? I am mostly
    interested in doing it with ADOExpress in D5. I need it for files
    created with Access 97 and newer versions.

    Thx

    Igor

  • Next message: Brian Bushay TeamB: "Re: Refresh TADODataSet within OnPostError?"

    Relevant Pages

    • Re: How to enforce subtypes/supertypes in Access 2000?
      ... So I focussed on the dirty event. ... If I code everything using DAO now, will I need to re-code everything ... into ADO later, or does VB.Net not care which one you reference? ... Will they be packaged with my .mdb file if I ...
      (microsoft.public.access.tablesdbdesign)
    • Re: Unable to open Acces files on a server
      ... Access file through ADO, which does not need either to start ACCESS ... manipulate data n that *MDB file (Assume you do it in a stand-alone VB app ... > Dim MyConn As ADODB.Connection ... > Set MyConn = New ADODB.Connection ...
      (microsoft.public.vb.general.discussion)
    • Re: Performance problem
      ... I was doing an unnecessary SQLAllocHandle and SQLFree inside a tight loop which when removed got things going again. ... It's certainly might, the one big advantage of using a mdb file is that jet 4.0 ships with windows, and windows vista right out of the box. ... The beauty of this approach would be that you would be able to run your code on Windows XP, or vista without installing additional software libraries (you'll likely have to include a ado reference in the project that you create, but other than that you would not be beholden to using MS access for your application. ...
      (microsoft.public.access.gettingstarted)
    • Re: Any REAL reason to use ADO vs. DAO?
      ... Not only should the tests be limited to a .mdb file, ... specify the Connection String (provider, file location, etc) as well as ... Cursor Types, Locations, DAO and ADO versions. ...
      (microsoft.public.vb.general.discussion)
    • Re: CONNECT MDB FILE FROM ADP FILE
      ... Just use ADO ... anyone using DAO is too rusty ... From a adp project connnected to a MSDE database, i have local setting in a ... local mdb file. ...
      (microsoft.public.access.adp.sqlserver)