What is Access Doing Automatically?

  • Thread starter Thread starter Lola
  • Start date Start date
L

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?
 
When files are deleted they are not removed. That is they stay in the
file until it is compressed. Try compressing the database. My guess is
temporary files are being created and you need to delete them.
 
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.
 
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
 
Back
Top