Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Compact and Repair

    I am getting an error when trying to compact and Repair a 200 meg database using Access 2010.

    The database was created and works fine in 2003. It seems to run fine in 2010, but it will not compact.

    The error reads...

    The query cannot complete. Either the size of the query results is larger than maximum size of the database (2 GB), or there is not enough tempory storage space on the disk to store the query result.


    Any ideas on what might be the issue?


    Thanks
    Richard

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Are you able to compact the database in 2003? I've run the 2010 compact and repair on several large databases successfully, and I've not seen others reporting issues with it. Thus it sounds like there may be some sort of issue with the .mdb file. Have you tried importing all of the objects into a new database, and then running the compact?
    Wendell

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The compact and repair does run correctly in 2003. The db ends up about 175 meg. I did run the compact on the db in 2010 and it took the database from 325 meg down to about 225 meg, so it seem to be working now.

    Not sure what I did different, but HEY it is working.


    Thanks
    Richard

Posting Permissions

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