Microsoft Access97/2K problem !!

[larva]

Hi guys,

I found a bug for Access 97/2K where the size of the file will keep on increasing forever eventhough u have deleted all the data inside the database. For example, I have 20K records inside the access database andthe size of the file is 30MB and after I deleted 19K records from the database, the size of the file still remain the same, which is 30MB. If I try to insert 1K records into it, which is now have 2K records in it, the size of the file has increased to like 32MB. Anyway to fix this problem. Please help !!

Thanks & regards,
Larva

 

[NeoV]

tools - compact database

 

[larva]

How to compact the access97/2K database ?

 

[BFG10K]

Tools -> Database Utilities -> Compact And Repair Database.

 

[larva]

Hi,

But shouldn't Microsoft set this function to auto ? I means once records deleted from the access database, the size of the file should automatically reduce !

Larva

 

[EagleKeeper]

Originally posted by: larva
Hi,

But shouldn't Microsoft set this function to auto ? I means once records deleted from the access database, the size of the file should automatically reduce !

Larva

There is a rollback function which can allow the recovery (in theory) of deleted records. That is why the data file does not shrink.
The compress actually removes the data records.

The standard delete acts similar to the delete file does in DOS. It removes a pointer to the file from the directory but does not actually delete the file. That is why undelete will work (or the recycle bin in Windows).

 

[CJ]

You can also set the db to compact and repair on close by choosing Tools-->Options-->General and checking "Compact on Close".