DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Compacting and Repairing MDB's in ADO

  1. #1
    Filipo Novo Mór Guest

    Compacting and Repairing MDB's in ADO



    Actually ADO has the compact and repair database functions. To use it,
    you have to reference the ADOX library (Microsoft ADO Ext. 2.6 for DDL and
    Security), a subset of ADO. This library is distributed in the MDAC26RTM
    package.

    Filipo

    "marc" <whale@ultranet.com> wrote:
    >
    >Microsoft has stopped developing dao, ado is the way of the future. However,
    >there are somethings dao does that ado can not do yet. I would therefore
    >use ado where ever possible. An example of an unsupported function is repairing
    >an access database (to the best of my knowledge this has not been added

    to
    >ado yet). DAO is faster with access databases.
    >
    >Marc
    >
    >
    >"joe" <jj@hat> wrote:
    >>hi...
    >>i've developed some database application using vb and ado object V 3.5


  2. #2
    Chris Hylton Guest

    Re: Compacting and Repairing MDB's in ADO


    Does anybody actually know if this works correctly...compact and repair from
    ADOX...

    The functionality in DAO doesn't really do the job correctly, there is a
    glitch in it that I discovered years ago and never did find a solution or
    get MS to resolve it although they admitted there were problems w/ the DAO
    method/function.

    Try it sometime, get a database that's gotten huge make two copies of it.
    Then, let DAO compact one and do a compact from inside Access w/ the menu
    pick on the other one. You are likely to find that the DAO method/function
    doesn't compact it as much. There is no rhyme or reason I've found...so
    you may have to try multiple databases to replicate the results I've mentioned.

    Anyway...I just wondered if anybody has seen similar results in ADOX ???

    Chris

    "Filipo Novo Mór" <fmor@terra.com.br> wrote:
    >
    >
    > Actually ADO has the compact and repair database functions. To use it,
    >you have to reference the ADOX library (Microsoft ADO Ext. 2.6 for DDL and
    >Security), a subset of ADO. This library is distributed in the MDAC26RTM
    >package.
    >
    > Filipo
    >
    >"marc" <whale@ultranet.com> wrote:
    >>
    >>Microsoft has stopped developing dao, ado is the way of the future. However,
    >>there are somethings dao does that ado can not do yet. I would therefore
    >>use ado where ever possible. An example of an unsupported function is

    repairing
    >>an access database (to the best of my knowledge this has not been added

    >to
    >>ado yet). DAO is faster with access databases.
    >>
    >>Marc
    >>
    >>
    >>"joe" <jj@hat> wrote:
    >>>hi...
    >>>i've developed some database application using vb and ado object V 3.5



  3. #3
    marc Guest

    Re: Compacting and Repairing MDB's in ADO


    I know of compact a database through JRO, I was not aware there is a repair
    function. Where is it.

    Marc

    "Filipo Novo Mór" <fmor@terra.com.br> wrote:
    >
    >
    > Actually ADO has the compact and repair database functions. To use it,
    >you have to reference the ADOX library (Microsoft ADO Ext. 2.6 for DDL and
    >Security), a subset of ADO. This library is distributed in the MDAC26RTM
    >package.
    >
    > Filipo
    >
    >"marc" <whale@ultranet.com> wrote:
    >>
    >>Microsoft has stopped developing dao, ado is the way of the future. However,
    >>there are somethings dao does that ado can not do yet. I would therefore
    >>use ado where ever possible. An example of an unsupported function is

    repairing
    >>an access database (to the best of my knowledge this has not been added

    >to
    >>ado yet). DAO is faster with access databases.
    >>
    >>Marc
    >>
    >>
    >>"joe" <jj@hat> wrote:
    >>>hi...
    >>>i've developed some database application using vb and ado object V 3.5



  4. #4
    Chris Hylton Guest

    Re: Compacting and Repairing MDB's in ADO


    It's been awhile since I used them, but DAO offers a number of functions,
    called directly w/o any preliminary object being declared...just like using
    opendatabase. Those are compactdatabae or compactdb (cant' remember which
    one is right) and similarly for repairdatabase/repairdb.

    But, as I said...I've found that they don't do the job correctly in all instances.
    I also tested JRO back when I discovered this problem, as mentioned above,
    with a third copy of a uncompressed database, but I don't remember whether
    JRO did it correctly or not, I seem to recall NO because I think it uses
    these functions mentioned above.

    Chris

    "marc" <whale@ultranet.com> wrote:
    >
    >I know of compact a database through JRO, I was not aware there is a repair
    >function. Where is it.
    >
    >Marc
    >
    >"Filipo Novo Mór" <fmor@terra.com.br> wrote:
    >>
    >>
    >> Actually ADO has the compact and repair database functions. To use it,
    >>you have to reference the ADOX library (Microsoft ADO Ext. 2.6 for DDL

    and
    >>Security), a subset of ADO. This library is distributed in the MDAC26RTM
    >>package.
    >>
    >> Filipo
    >>
    >>"marc" <whale@ultranet.com> wrote:
    >>>
    >>>Microsoft has stopped developing dao, ado is the way of the future. However,
    >>>there are somethings dao does that ado can not do yet. I would therefore
    >>>use ado where ever possible. An example of an unsupported function is

    >repairing
    >>>an access database (to the best of my knowledge this has not been added

    >>to
    >>>ado yet). DAO is faster with access databases.
    >>>
    >>>Marc
    >>>
    >>>
    >>>"joe" <jj@hat> wrote:
    >>>>hi...
    >>>>i've developed some database application using vb and ado object V 3.5

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center