Size of Dbase

  • Thread starter Thread starter Sanj
  • Start date Start date
S

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
 
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.
 
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
Click to expand...

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.
 
Back
Top