Hi friends,

  How to compact my Access Database. Eventhough the records are very less the size of the database is more. How come it is like that?
PLs, clearify my doubt.

Thanks

In Access XP (2002) click on TOOLS > DATABASE UTILITIES > COMPACT AND REPAIR DATABASE (it's probably the same for Access 2000 and 2003). As you add/delete/update data, Access does not recover any gained disk space automatically.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division