Why became my database file 5 times larger in Access 2007?

[Guest]

I have a database in Access 2000 file format witch I have developed for
several years. The filesize is 4,9 MB. When I resently moved this file to my
new notebook with Windows Vista and Access 2007, and filled it with with a
certain amount if information (not that much, there was allredy some ground
information written to it), I notized the file size had grown to 26,8 MB,
more than 5 times larger. I have allso another copy of the same database on
my notebook, witch I only have opened a couple of times and not written much
to. This file has not grown at all. Anyone who knows what this is about?

 

[Allen Browne]

Try compacting your Access 2007 file:
Office Button | Manage | Compact/Repair

 

[Guest]

Thanks for your answer.
Yes, the filesize became much smaller (1,7 MB).
But then it begins to grow again, while the file is open. I can actually see
in the explorer window how it grows, about 20 kb every 10 seconds. And I'm
doing nothing! What is happening? Can it be a virus? But I have a good and
updated virusprogram, and no other files than my Access files are effected
(now allso the other one I mentioned in my first question).

Robbie

"Allen Browne" skrev:

 

[Allen Browne]

Could be due to a number of things--Name AutoCorrect to name one example.
You probably want to turn this one off anyway:
http://allenbrowne.com/bug-03.html

Beyond that, be aware of what might decompile your database, avoid Timer
events, and so on.

Of course, if you are adding data to a table and deleting it, that will
bloat your database also.

 

[Guest]

Thanks for your tips, but it didn't help.
Robbie

"Allen Browne" skrev: