optimize database

[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

 

[Maik Siegel]

Use under "Compact and Repair Database" from Mainmenue


--
Best Whishes, Maik


Knowledge is Power
Replace [at] and remove [NOSPAM] to get Email-Adress

 

[dawn]

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.