Back End is GROWING!!

  • Thread starter Thread starter Donna Thornhill
  • Start date Start date
D

Donna Thornhill

We recently split the our db. BE and MDW shared on
server, FE copied to each user's workstation. I expected
the FE to grow because I thought the growth was at least
partially due to space utilized when queries are run.
However, the BE has started growing. We did a compact and
repair about 1-1/2 hours ago and it went from 35 MB to
13MB afterwards. Now it is back up to 24MB. Any
suggestions?
 
We recently split the our db. BE and MDW shared on
server, FE copied to each user's workstation. I expected
the FE to grow because I thought the growth was at least
partially due to space utilized when queries are run.
However, the BE has started growing. We did a compact and
repair about 1-1/2 hours ago and it went from 35 MB to
13MB afterwards. Now it is back up to 24MB. Any
suggestions?
Click to expand...

Do you create temp tables? or append data into tables and then delete
it, and append more? Does your backend machine have PLENTY of memory
(memory's cheap... 256MByte is a reasonable start).

There will always be *some* bloat, and compaction is essential in any
working database. This seems pretty drastic though!
 
Donna Thornhill said:
We recently split the our db. BE and MDW shared on
server, FE copied to each user's workstation. I expected
the FE to grow because I thought the growth was at least
partially due to space utilized when queries are run.
However, the BE has started growing. We did a compact and
repair about 1-1/2 hours ago and it went from 35 MB to
13MB afterwards. Now it is back up to 24MB.
Click to expand...

A certain amount of growth, say 20% or 40% is normal the first day or
two but yours is definitely high.

Are different versions of Jet installed on the various workstation
computers? What I've done is use the various API calls available and
am checking the version number and date/time of a crucial dll,
msjetxx.dll, to ensure it matches what I have on my system. See the
tips page at my website for more details including sample code: Verify
Appropriate Jet Service Pack is installed
www.granite.ab.ca\access\verifyjetsp.htm

Are you doing lots of temporary table creating/deleting or
adding/deleting lots of records from tables? If so see the
TempTables.MDB page at my website which illustrates how to use a
temporary MDB in your app.

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
 
Back
Top