Size of Dbase

[Sanj]

Size of my dBase is 1.4GB. I deleted a table of half the
size I originally have from database but it still shows
1.4GB?? Can anybody explain this ..Thanks

Sanje

 

[Albert D. Kallal]

Try going tools->compact and repair.


All records and data space is not re-claimed until you do a compact. Most
pc based database systems have been this way for about 20 years now.

You should compact on a frequent basis, especially if you have any code that
uses temp data tables. As a general rule, you want to avoid code, and
designs that rely on temp data tables.

 

[John Vinson]

Size of my dBase is 1.4GB. I deleted a table of half the
size I originally have from database but it still shows
1.4GB?? Can anybody explain this ..Thanks

Sanje

Use Tools... Database Utilities... Compact and Repair Database.

Access does NOT recover waste space, after deleting tables, records,
or code. Compaction is *essential* regular maintenance.