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