Access database file size increase constantly...

Posted on 2009-12-17
Last Modified: 2013-12-22
Hi everyone,

I have an access database which consists of a switchboard, other various forms and around 35 tables.  Recently I have noticed the file size increasing massively when inputting minimal data.  

This morning I added around 80 rows of information into one of the tables, and it increased the file size from 7.4Mb to 14.8Mb, and the table already had around 900 lines of information inside it.  

Any ideas why this is happening?  could it be corrupt? Any help would be much appreciated.

Many Thanks,

Question by:choy77
    LVL 4

    Accepted Solution

    Access inherently grows over use. This is fact. Periodically, you will have
    to compact the database to reduce the size. This has nothing to do with the
    queries themselves, but the data that the queries return. As the queries
    run, different amounts of records are returned. This action will create
    'bloat' within the database. Once you run compact/repair on the database, it
    removes that 'bloat'. The degree to which it compacts may not result in the
    file returning to the same size. So remember, even after compacting the file
    may be slightly larger than the last compact.

    Other than this, when you designed your tables, I take it you didn't just make all the test field size 255 - you scoped them correctly?

    LVL 10

    Assisted Solution


    Go to file click on compact and repair. This will compact the database and reduce the file size. Please make a backup before you do it to be on the safer side.

    LVL 10

    Expert Comment

    Have you decompiled your database to flush the old copies of pre-compiled VBA code?
    See my paper for more info:
    Good luck!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why spend so long doing email signature updates?

    Do you spend loads of your time carrying out email signature updates? Not very interesting are they? Don’t let signature updates get you down. Let Exclaimer Cloud - Signatures for Office 365 make managing email signatures a breeze.

    A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
    If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
    With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
    The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now