Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Compact and Repair Database not working? ((a2k (9.0.6926) SP-3 Jet 4.0 SP-8) )

    All of a sudden, at one of my client sites, when I run Compact and Repair Database on backend database Build_be.mdb I

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Compact and Repair Database not working? ((a2k (9.0.6926) SP-3 Jet 4.0

    When you run compact and repair, the database is compacted to an arbitrary name, like db1.mdb, and then that database is renamed after the original is deleted. Occasionally, especially when attempting this on a mapped network drive, something goes wrong and Access decides it cannot finish the process. Have you checked the permissions on the network drive? I used to see this a lot with Access 2000 but haven't encountered it in 2002.
    Charlotte

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compact and Repair Database not working? ((a2k (9.0.6926) SP-3 Jet 4.0

    That sounds like what might happen if you do not have "Create" permission on the network folder where the file is located.
    Legare Coleman

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compact and Repair Database not working? ((a2k (9.0.6926) SP-3 Jet 4.0

    Hi Charlotte & Legare

    I don

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Compact and Repair Database not working? ((a2k (9.0.6926) SP-3 Jet 4.0

    John

    Has the database, got security levels set? If so,

    This may help


    It is a piece of code that gets around the problem of security levels in databases
    Jerry

Posting Permissions

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