[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1875
  • Last Modified:

Access database file size increase constantly...

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,

Chris
0
choy77
Asked:
choy77
2 Solutions
 
barnesd1Commented:
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?

HTH
Dave
0
 
moon_blue69Commented:
Hi

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.

cheers
0
 
Luke ChungPresidentCommented:
Have you decompiled your database to flush the old copies of pre-compiled VBA code?
See my paper for more info: http://www.fmsinc.com/microsoftaccess/performance/decompile.asp
Good luck!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now