Database Size

  • Thread starter Thread starter Neily
  • Start date Start date
N

Neily

Hi,

I designed a database into which I loaded a good number of
records taking the size of the database up to around
128Mb. After this I deleted all the records and expected
the size to come back down as well.

Does anyone know if this is normal and if not does anyone
know what is causing it. I'm running it on Windows NT.

Thanks

Neily
 
Access does not automatically release the space consumed by deleted records
or objects. To recapture that space, do a Compact & Repair.
 
I found this out the hard way. Even though you may delete
the records in a table OR delete the table, Access does
not free up that space. The database needs to be deleted
and you can start over from there. The max size for the
database is 2g. I am tring to find a way of automatically
deleting a database then recreating it but have had no
luck, so far.
 
I found this out the hard way. Even though you may delete
the records in a table OR delete the table, Access does
not free up that space.
Correct.

The database needs to be deleted
and you can start over from there.
Click to expand...

ABSOLUTELY INCORRECT.

Tools... Database Utilities... Compact and Repair Database recovers
the lost space, and it's basic, routine maintenance for any database.

A2000 and later have an option to automatically "compact on close".
 
Back
Top