Last post Sep 06, 2005 04:53 AM by hauruapai
Sep 01, 2005 07:53 PM|hauruapai|LINK
Sep 02, 2005 01:16 AM|MobileNow|LINK
Sep 02, 2005 12:53 PM|ecktwo|LINK
Sep 02, 2005 10:29 PM|hauruapai|LINK
Thank you both for your help :-)
I found that there was a ldb file that was old and got it deleted and that fixed it.
I also did think of compressing but the DNN db was 39mb and compacted to 4mb - is this normal to compact so much? I did the compact on a copy but have not tried it as 25mb compact seemed to me to be a bit excessive! Would the compacted 4mb db be still ok
thank you once again for your time and help :-)
Sep 02, 2005 11:06 PM|cathal|LINK
MS Access does a poor job of clearing up empty space due to it's design. If you have volatile elements that get filled up, and cleared down regularly (such as the sitelog table), it's quite possible to see a reduction in size of this magnitude. The 4MB database
will be ok to use. Note: always backup your database before compacting, as it can be corrupted on occasion.
Sep 06, 2005 04:53 AM|hauruapai|LINK