Problem with Database Size

[vikasbhandari2]

Hey all,

I am not very gud in access, so I need your help. I am facing a strange problem..... I have created a database which consists of four tables....out of which two tables have relationships. When I make my database and create all the tables as described...its initial size is 320 KB around. When I put data in it, its size increases accordingly....I noticed a strange thing that when I entered some data in my Database it reached around 5MB, but when I deleted all the records from all the tables, the database size didn't decrease. It actually remained of the same size 5MB.......

Why so??? Don't you think that the database size should be decreased when I delete my records from all the tables. Is there any option which I need to select to decrease the database directly??? Well just FYI, I am using JAVA as front end .......

Regards,
Vikas Bhandari

 

[supercharge]

Go to your Access menu, select Tools, Database Utilities and then select Compact and Repair...

Doing that will reduce the size dramatically.

Give it a shot, will yah?

 

[vikasbhandari2]

Thanks

Thanks, I will definitely try it wen I will reach to home... Thanks a lot