Size of Access Growing

[Echo]

Hi,

I had challenge to limit the size of Access on our share
drive, I do not understand the reason that Access can grow
so fast, avg. 0.5GB per month, can anybody help how to
handle rather than I have to create a new access prgram
contains form, query and etc.

Thanks
Echo

 

[Guest]

have you tried to repair /compact yuur database?

 

[Guest]

I dont know why but Access database keeps increasing in size as go on using.
Even if you compact and repair the database. What I did was after couple of
months I would export all the objects(EVERYTHING) into a new database and
start all over again.

vb

 

[Lynn Trapp]

Are you storing any pictures in the database?

 

[Guest]

I have a burgeoning DB also. I saw something about querys hogging up space,
and I am trying to find the technical article, because I suspect it may
address the problem.

 

[Ken Snell]

See if this MS Knowledge Base article relates to your situation:

http://support.microsoft.com/default.aspx?scid=kb;en-us;810415&Product=acc2003

 

[Tom Wickerath]

Here are some additional things to check out regarding .mdb file bloat:
http://tinyurl.com/2dmpw

Tom
_________________________________

I have a burgeoning DB also. I saw something about querys hogging up space,
and I am trying to find the technical article, because I suspect it may
address the problem.

 

[Tony Toews]

I had challenge to limit the size of Access on our share
drive, I do not understand the reason that Access can grow
so fast, avg. 0.5GB per month, can anybody help how to
handle rather than I have to create a new access prgram
contains form, query and etc.

Is this the front end or the back end?

A few causes of Front End (FE) bloat are:
- using temporary tables in front end for data importing or report
performance
- images, such as corporate logos on many forms and reports
- explicitly close recordsets
- some other more obscure problems

For more info see the Bloating Front End (FE) Microsoft Access
MDB/MDEs Tips page at my website at
http://www.granite.ab.ca/access/bloatfe.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Echo]

I have done the same thing as you, but I have got more
than 60 queries and 30 tables, 25 reports and etc., just
too much to do so...

Any other options?

 

[Douglas J. Steele]

It's actually easier if you start with an empty database and import all of
the objects in. The amount of work to do this isn't related to how many
objects are in the database. Select File | Get External Data | Import from
the menu. Once you've selected the database to import everything from, each
of the 6 tabs on the Import Objects dialog has a Select All option. 12
clicks in all (6 clicks on the Select All button, 5 clicks to get to each of
the tabs, and 1 click on the OK button)

 

[Tom Wickerath]

However, if you want to go with the recommendation of the FMS experts, which is to import each
group SEPARATELY, then you'll have a few more clicks. Still not bad.

http://www.fmsinc.com/ubb/Forum12/HTML/000285.html

Tom
_______________________________________________


It's actually easier if you start with an empty database and import all of
the objects in. The amount of work to do this isn't related to how many
objects are in the database. Select File | Get External Data | Import from
the menu. Once you've selected the database to import everything from, each
of the 6 tabs on the Import Objects dialog has a Select All option. 12
clicks in all (6 clicks on the Select All button, 5 clicks to get to each of
the tabs, and 1 click on the OK button)

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

_______________________________________________