Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2011
    Posts
    29

    Unanswered: How to reduce the size of the Access FE mdb

    My A2003 FE mdb has grown over the years and is now about 180Mb.

    Is it advisable to copy the contents of the FE mdb into a blank A2003, every few months, in an attempt to make it smaller?

    Is there something to watch out for during the copy?

    John

  2. #2
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388
    Try the Compact and Repair Menu item

  3. #3
    Join Date
    Sep 2011
    Posts
    29
    Thanks for the reply. The 180Mb is after Compact and Repair.

    Not all FE tables are linked to the BE.

    One thing to consider is that the A2003 FE mdb is about 180Mb, while the same converted to A2013 FE is about 72Mb. Is this normal?

    John

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    always, always back up before a compact and repair
    consider periodically importing all objects into a new DB (say every 6..12 months or so), can't guarantee it does anything, but I know Im starting with a new clean mdb/accdb.
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    180mb FE... what the feck is in their
    surely you can';t have that many forms and reports
    how much data are you storing locally
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Sep 2011
    Posts
    29
    If it helps, the mde (derived from the 180Mb mdb) is only 63Mb.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •