Releasing the MDB

[Guest]

I have created a basic application in Access that has Forms, queries and
tables(Local and linked(SQL)). I recently released the application to some
users and have noticed that the size of the MDB is increasing. The
application only allows the users to inquire and produce reports. I would
expect the size of the MDB to remain the same. If you have any ideas, I
would appreciate it. Thanks

 

[Guest]

Instead of "releasing the MDB" to your user population, which would allow
them to modify the database, instead save the MDB as an MDE - tools/database
utilities/make MDE. MDE is basically the Access equivalent to an EXE file -
allows execution without modification. That will keep the mdb safe from
accidental user errors like deleting forms, etc. and also keep your mdb size
from growing. If your users need the ability to modify queries, store those
in a different MDB from your "application".

However, if you setup the MDB to compact on exit - your size will stay in
control also. Compact/repair is the way to keep the temp storage junk under
control.

 

[Guest]

A small amount of DB growth is normal. I once ran a test with the Northwind
sample database, by opening various reports, which caused queries used as the
underlying recordsource to run. If I recall correctly--this test was several
years ago--the database grew on average about 4 KB each time I opened a
report. This type of growth should be considered normal. Compacting the
database on a regular basis should reclaim this space.

If your database is bloating wildly, then check out the various KB articles
that can be found here:

http://tinyurl.com/2dmpw

If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?" at the bottom of the message thread.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I have created a basic application in Access that has Forms, queries and
tables(Local and linked(SQL)). I recently released the application to some
users and have noticed that the size of the MDB is increasing. The
application only allows the users to inquire and produce reports. I would
expect the size of the MDB to remain the same. If you have any ideas, I
would appreciate it. Thanks