Re: Rapidly expanding MS Access data file size

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

> The app runs fine except that the size of the access file grows rather
> alarmingly quickly. i.e. 3->14Mbyte in 2 hours. If you terminate and
> merely
> 'Compact & repair the database' the size goes back to the original 3 Mb.
>
> I've doublechecked the code looking for obvious problems - making sure all
> recordsets get closed etc - everything looks fine.

I don't think anything is wrong. It's normal behaviour for Access increase
in size when you add and delete tables and records (the records aren't
actually deleted until you Compact and Repair - hence the increasing size).
Just compact regularly (maybe several times a day) and you should be fine.
Under Tools > Options you can set Compact on Close to True and close and
reopen the app now and then.

Jesper


.

Relevant Pages

  • Re: "There isnt enough memory to perform this operation"
    ... Our method of dealing with the problem so far is saving a lot and Compact & ... leaving Design mode. ... Run Compact & Repair on one of the copies. ... large app -- about 72 MB of program with tables linked to another Access ...
    (microsoft.public.access.tablesdbdesign)
  • Re: #Name? error
    ... Have you done a compact and repair, or a decompile followed by compact and ... What happens if you create another database as a test, keep it simple, use ... Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia ...
    (microsoft.public.access.forms)
  • Re: Form Dirty not firing
    ... also forces me to do a backup and compact and repair again. ... MISSING references. ... Database Utilites... ...
    (microsoft.public.access.formscoding)
  • Re: Re-ordering of Tables
    ... clustered index (MSDE) then that is the exception. ... In the case of a compact and repair, the rows added subsequently would not ... clustered index but that has nothing to do with the question at hand. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: linked table problem and need advice
    ... It probably was a corruption problem that you probably fixed with the ... I'd run the Compact and Repair a few more times to be ... If you do decompile, make sure to have a backup copy. ...
    (microsoft.public.access.gettingstarted)