Forum Discussion

Dave_Sleeman's avatar
Dave_Sleeman
Copper Contributor
May 24, 2023

Compact & Repair

My data base is getting on the large size, so decided to do a Compact & Repair - have used this option in the past OK.   With D/B opened selected the Compact & Repair option in File> Options > Compac...
access
George_Hepworth's avatar
George_Hepworth
Silver Contributor
May 25, 2023

Dave_Sleeman 

Okay, that eliminates one possible source of the problem.

I assume that you know the password because you set it yourself.  Because the error message indicates that you are using the wrong password,  we do have to eliminate that as a possibility.

 

When you open it, though, the same password DOES work?

 

  • Dave_Sleeman's avatar
    Dave_Sleeman
    Copper Contributor
    May 26, 2023

    George_Hepworth 

     

    Good day George

    I set the original Password and the Password on the data-base works fine on Opening.

    I have checked and triple checked that I am using the correct password when attempting to run the Compact and Repair.   I have made sure that Caps lock is not having an impact.   I have run the Compact and Repair on the data-base in the past and it has worked fine.

    I Copy the file to a Backup Drive once a month after the Compact and Repair.  Results show

    file size was 63,032 Kb in January, then 62,936 kb in March, and in April 145,568 kb.

     

    Regards

     

    Dave Sleeman