(Leo) Access file size

L

Leo

I copied an access file and on its new copy , I deleted most of tables'
contents to reuse its structure with new data.
but I found that my new file which expected to be lighter with empty (or
less data tables) has bigger size shown on the Window.
How can this logically possible??
 
N

Nikos Yannacopoulos

Leo,

To recover the unused space, go Tools > Database Utilities > Compact and
Repair database. This process also re-indexes the database, speeding it
up and preventing corruptions, so it's good to do it regularly.

HTH,
Nikos
 
A

Arvin Meyer

Leo said:
I copied an access file and on its new copy , I deleted most of tables'
contents to reuse its structure with new data.
but I found that my new file which expected to be lighter with empty (or
less data tables) has bigger size shown on the Window.
How can this logically possible??
Click to expand...

Because the space isn't reclaimed until the database is compacted. On the
menu - Tools ... Database Utilities ... Compact and Repair
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top