What is Access Doing Automatically?

[Lola]

As you utlize my system, (which is set up with a file for
programs and a file for data), the PROGRAM file is
growing - users do not have access to add change or delete
from the program file.But at the beginning of the day, the
file will be 19,328 and at the end of the day it is ove
39,000.

Any thoughts? I think I am lossing my mind?

Does Access do something in the background?

 

[Albert D. Kallal]

When you delete records, the spaced used by them is NOT returned.

You need to do a compact on the file. Compacting is NOT to be confused with
compression utilities like WinZip.

Most pc database systems have some utility to remove deleted records, and
re-claim space. In the old dbase days, the command was actually called pack.

Anyway, the solution is to compact frequently. You also should design your
code to avoid using temp tables.

 

[ALAN]

Do you compact on closing?

 

[David Straker]

If you have VB code modules/classes, does the front-end mdb need to be
compiled and saved (and then compacted)? It doesn't hurt to automatically
compact on closing but you shouldn't get this kind of bloat anyway unless
there are temporary Access objects or records being created and deleted at
run-time in the front-end. Do you create temporary tables, queries, records,
etc. and delete them in code?

David Straker