Access file unexpectadly decreased in size -
i've been working on access database when noticed size of file had decreased 23mb 4mb when compared backup made last week. understand kind of behaviour might expected if compacted , repaierd it, haven't done in while.
i've run comparisons on 2 databases, , beside few changes i've made week, data, forms, reports, modules , queries seem same. i'm wondering if kind of pointer towards iminent corruption (which has happened once before on earlier version of database), or if there other explanation.
i have 1 on 400mb in size, multiple users in time. when chance, i'll compact , goes ~100mb.
if want development, i'll save current copy flash drive , work on copy. saving in location, goes ~100mb.
you did made few changes, , if things safely, made changes non-production copy. reason shrinking.
-edit choosing copy/paste location not shrink it, "save as" me.
Comments
Post a Comment