Hi Nitin,
The posts by Eric and Ken are right, repair and compact is the answer to the
"what do I do" portion of your question. As to the "why does this happen"
part, most database packages do not do a physical delete when a "DELETE" SQL
statement comes in. Rather, the records to be deleted are marked with a
"tombstone" that indicates that they are logically deleted. To physically
remove them, a "shrink" operation needs to be invoked. In the case of
Microsoft Access, that is taken care of by the Repair (reindex) and Compact
(physically remove all records marked for deletion).
HTH,
Derrick
"Nitin" <lo*******@yahoo.com> wrote in message
news:uZ**************@TK2MSFTNGP15.phx.gbl...
I am using access database for my application, whenever I insert records
the size of the data base increases, But when I delete the records the
database size does not decrease. What is the problem???
ThanX
Nitin