• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Microsoft Access97/2K problem !!

L

larva

Member
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
 
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
 
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
Click to expand...

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).

 
You can also set the db to compact and repair on close by choosing Tools-->Options-->General and checking "Compact on Close".
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top