Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    60

    Unanswered: Size of Access Database

    Everyone,
    Is there a way using which the size of the access database can be compressed without turning off any insertion of records or forcibly logging off any users.
    We have an Access database, which has a table (table A) is populated by a process every 2 minutes. Every night, we archive table A records to another table after summarizing the records by an hour. After archiving we delete records from table A. However, this is not releasing the space occupied by table A. We don't want to bring down the database in case we want to use Compact and Repair feature. Any thoughts?

    Thank you all in advance,
    Saurav

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    That's all you can do, compact and repair.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Aug 2003
    Posts
    60
    Thanks a lot for the reply!

Posting Permissions

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