Results 1 to 4 of 4
  1. #1
    crowegreg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Posts
    398

    Unable able to compact BE Database


    I'm trying to compact my BE DB. With the DB open, selecting File, Compact & Repair, it brings up a Password Required dialog box. When I enter the password for the DB, after clicking ok, the Password Required dialog box reappears. After entering the password a total of 3 times, it displays a box stating not a valid password. Clicking OK, it brings up another Password Required dialog box. After entering the same password, it opens the DB.

    I've tried to remove the password, but the same Password Required dialog box appears.

    I haven't had any problems with the BE DB. Once a week, I compact it to keep it minimized. Their are no users in the DB while attempting to compact.

    I've also tried copying the DB to my local drive, but I get the same results.

    Thanks in advance

  2. #2
    jwill is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Location
    MD
    Posts
    67
    You may want to move all of the objects to a new database.

  3. #3
    crowegreg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Posts
    398
    Thanks. I did that, and it solved my problem.

  4. #4
    jwill is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Location
    MD
    Posts
    67
    Glad I could help

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access 2.0, unable to open database
    By Raul in forum Access
    Replies: 8
    Last Post: 01-20-2014, 06:23 PM
  2. Replies: 4
    Last Post: 11-27-2013, 09:51 AM
  3. Will database auto compact and repair on the server?
    By squirrly in forum Programming
    Replies: 8
    Last Post: 04-15-2013, 02:37 PM
  4. Replies: 7
    Last Post: 11-11-2010, 11:16 AM
  5. Compact/Reapir doe not reduce database size
    By nosrepmodnar in forum Access
    Replies: 1
    Last Post: 10-23-2009, 02:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums