Compacting and repairing access 2000 db

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • John

    Compacting and repairing access 2000 db

    Hi

    Is it possible to compact and repair an external access 200 database via
    code?

    Thanks

    Regards


  • Spam Catcher

    #2
    Re: Compacting and repairing access 2000 db

    "William Vaughn [MVP]" <billvaNoSPAM@b etav.comwrote in news:F207E931-
    0C96-4038-A86E-FD7D628E6C3F@mi crosoft.com:
    Ah, no. It takes JRO.
    Isn't JRO part of ADO?

    That's what the knowledge base article says. Ha Ha.

    --
    spamhoneypot@ro gers.com (Do not e-mail)

    Comment

    • William Vaughn [MVP]

      #3
      Re: Compacting and repairing access 2000 db

      Not in any build/deployment I've seen... but it's been awhile.

      --
      _______________ _______________ _______________ _______________ ______________
      William R. Vaughn
      President and Founder Beta V Corporation
      Author, Mentor, Dad, Grandpa
      Microsoft MVP
      (425) 556-9205 (Pacific time)
      Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
      _______________ _______________ _______________ _______________ _______________ _______________ __
      "Spam Catcher" <spamhoneypot@r ogers.comwrote in message
      news:Xns9A6CA01 C44321usenethon eypotrogers@127 .0.0.1...
      "William Vaughn [MVP]" <billvaNoSPAM@b etav.comwrote in news:F207E931-
      0C96-4038-A86E-FD7D628E6C3F@mi crosoft.com:
      >
      >Ah, no. It takes JRO.
      >
      Isn't JRO part of ADO?
      >
      That's what the knowledge base article says. Ha Ha.
      >
      --
      spamhoneypot@ro gers.com (Do not e-mail)

      Comment

      • Spam Catcher

        #4
        Re: Compacting and repairing access 2000 db

        "William Vaughn [MVP]" <billvaNoSPAM@b etav.comwrote in
        news:1CBAB1DE-A82E-483E-A980-C34A3534157A@mi crosoft.com:
        Not in any build/deployment I've seen... but it's been awhile.
        >
        >That's what the knowledge base article says. Ha Ha.
        BTW, I was just being sarcastic ;-)

        --
        spamhoneypot@ro gers.com (Do not e-mail)

        Comment

        • Cor Ligthert[MVP]

          #5
          Re: Compacting and repairing access 2000 db

          >
          BTW, I was just being sarcastic ;-)
          >
          I thought it was meant to help Bill.

          As is proven is everybody using forever the same ways to solve things (and
          tell about that).

          In my idea does another light on that helps to improve that.

          Cor

          Comment

          • Paul Clement

            #6
            Re: Compacting and repairing access 2000 db

            On Tue, 25 Mar 2008 19:44:16 GMT, Spam Catcher <spamhoneypot@r ogers.comwrote:

            ¤
            ¤ Ah, no. It takes JRO.
            ¤
            ¤ Isn't JRO part of ADO?
            ¤

            Different library, actually an extension to ADO since it lacks the functionality - but they're both
            installed via MDAC.


            Paul
            ~~~~
            Microsoft MVP (Visual Basic)

            Comment

            Working...