Repair/Compact Database

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • zufie
    #1

    Repair/Compact Database

    When I Repair/Compact my Access databse. I get icons/copies of a
    database named db1.mdb, db2.mdb, db3.mdb, etc...

    How else may I repair this database?

    Thanks!,

    Zuf
    Tags: None
    • AndyB via AccessMonster.com
      #2
      Re: Repair/Compact Database

      Hi Zuf,

      If you open the database you wish to compact & repair, then it won't prompt
      you to save it with a new file name.

      When you compact & Repair a closed database, it always prompts you to save
      with a new file name.
      However, you can name it the same as the original file and choose to
      overwrite the original.

      Andy

      zufie wrote:
      >When I Repair/Compact my Access databse. I get icons/copies of a
      >database named db1.mdb, db2.mdb, db3.mdb, etc...
      >
      >How else may I repair this database?
      >
      >Thanks!,
      >
      >Zuf
      --
      Message posted via AccessMonster.c om
      http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200802/1


        Comment

        • paii, Ron
          #3
          Re: Repair/Compact Database


          "zufie" <john.marruffo@ illinois.govwro te in message
          news:28be8371-3006-4f7b-8e2b-9a489f328556@41 g2000hsc.google groups.com...
          When I Repair/Compact my Access databse. I get icons/copies of a
          database named db1.mdb, db2.mdb, db3.mdb, etc...
          >
          How else may I repair this database?
          >
          Thanks!,
          >
          Zuf
          IMHO a copy of the database during a Repair/Compact is a good thing.If you
          have an crash during a Repair/Compact to the same file, the MDB can be
          corrupted beyond repair.My process is to rename the original the
          Repair/Compact to the original file name.


            Comment

            • Greg
              #4
              Re: Repair/Compact Database


              On Feb 20, 12:10 pm, "paii, Ron" <n...@no.comwro te:
              "zufie" <john.marru...@ illinois.govwro te in message
              >
              news:28be8371-3006-4f7b-8e2b-9a489f328556@41 g2000hsc.google groups.com...
              >
              When I Repair/Compact my Access databse. I get icons/copies of a
              database named db1.mdb, db2.mdb, db3.mdb, etc...
              >
              How else may I repair this database?
              >
              Thanks!,
              >
              Zuf
              >
              IMHO a copy of the database during a Repair/Compact is a good thing.If you
              have an crash during a Repair/Compact to the same file, the MDB can be
              corrupted beyond repair.My process is to rename the original the
              Repair/Compact to the original file name.

                Comment

                • Greg
                  #5
                  Re: Repair/Compact Database


                  On Feb 20, 1:18 pm, Greg <CodeBo...@gmai l.comwrote:
                  On Feb 20, 12:10 pm, "paii, Ron" <n...@no.comwro te:
                  >
                  >
                  >
                  "zufie" <john.marru...@ illinois.govwro te in message
                  >
                  news:28be8371-3006-4f7b-8e2b-9a489f328556@41 g2000hsc.google groups.com...
                  >
                  When I Repair/Compact my Access databse. I get icons/copies of a
                  database named db1.mdb, db2.mdb, db3.mdb, etc...
                  >
                  How else may I repair this database?
                  >
                  Thanks!,
                  >
                  Zuf
                  >
                  IMHO a copy of the database during a Repair/Compact is a good thing.If you
                  have an crash during a Repair/Compact to the same file, the MDB can be
                  corrupted beyond repair.My process is to rename the original the
                  Repair/Compact to the original file name.- Hide quoted text -
                  >
                  - Show quoted text -

                    Comment

                    Previous template Next
                    Working...