Access 2000 database get huge in size.
As far as I know, this is perfectly normal. When deleting records out
of an Access database, you do not complety remove the information.
Well, you do but the space that was used by the information is not
released.
You just need to compact on a regular basis...
Quote:
>Problem with VB6.0 and Access 2000 format data base.
>When adding new records to a base, the .mdb file gets very big, and as
>consquence access time to the base becomes very long.
>Example : original file size is 475 kB
>We add 2500 new records (entries) to a table
>New file size is 10.9 MB
>We compact the database using Access 2000. The file is now 740 kB
>What are we doing wrong ?
>Same program connected to same data base, but in Access 97 format makes no
>problem...
>possible.
