How to reduce Acess Data base MDB file Size.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • PK Pradeep
    New Member
    • Mar 2008
    • 1

    How to reduce Acess Data base MDB file Size.

    Iam a fresher to the MS Acess world.
    Question is How to reduce the MDB file Size.

    I maintain a Access Data base where there are 5 Tables with each table containing 60, 000+ lines. If I delete the data by just blocking and delete from each table will my MDB size of the file will get reduced.
  • FishVal
    Recognized Expert Specialist
    • Jun 2007
    • 2656

    #2
    Not really. MDB size will remain the same until you do Main menu > Tools > Database Utilities > Compact and Repair Database.

    Regards,
    Fish

    Comment

    Working...