optimize database

  • Thread starter Thread starter Deepak
  • Start date Start date
D

Deepak

Goodevening everyone

My access 2000 tables contains around 960 rows and increasing at the rate of
20 rows per day.

Currently, the database size is 10.3 MB.

Now my problem is:
a) How can i reduce its size?
b) If i make a copy of database and save it to another location, and delete
all records from all the tables, the size is stll 10.3 MB. Can it be
reduced.

Please suggest and help

Deepak
 
Use under "Compact and Repair Database" from Mainmenue


--
Best Whishes, Maik


Knowledge is Power
Replace [at] and remove [NOSPAM] to get Email-Adress
 
access does not release unused space automatically (thus
deleting records doesn't effect the size of the database
at all).

You need to compact the database by selecting
TOOLS/DATABASE UTILITIES/COMPACT AND REPAIR from the main
menu. You can set the database to auto compact on close
by choosing TOOLS/OPTIONS and selecting compact on close
from the general tab.
 
Back
Top