Compacting .mdb database

Results 1 to 2 of 2

Thread: Compacting .mdb database

  1. #1
    Join Date
    Dec 1969

    Default Compacting .mdb database

    Hello,<BR><BR>I have a question about compacting an Access database. First off, what *is* compacting anyway? I assume no data is lost and performance improves...?<BR><BR>Here&#039;s why I ask. I have a database on my site that I&#039;ve been administering with 2eNetWorx&#039;s Table Editor. There&#039;s an option to compact the database but I don&#039;t want to do that if there&#039;s a high chance of any problems.<BR><BR>Can someone make me feel more secure about doing this? Hehe.<BR><BR>Thank you lots! :-)

  2. #2
    Join Date
    Dec 1969

    Default RE: Compacting .mdb database

    It&#039;s a good thing, and you should do this.<BR><BR>What it does is rebuilding the indexes and cleaning up.<BR><BR>When you delete a record in Access, the record isn&#039;t deleted just marked for deletion. When you compact the db these records are deleted.<BR><BR>I&#039;ve done this dozens of times, and it didn&#039;t go wrong but better safe than sorry so I would recommend making a backup.

Posting Permissions

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