Read-only MDB file increases in size on network

[Xavier J]

I have an MDB shared on our network by approx. 11 Access
2000 and one Access XP user. It's a frontend for data on
our SQL server.

My original file compacts to 2 mb, but it seems to balloon
to 128 mb each time I put it in production use on the
network. This even happens when the file is marked read-
only!

Eventually the file ends up getting corrupted and I just
replace it. This will work in the short term, but what to
do otherwise???

TIA for your suggestions.

 

[Kevin @ 3NF]

Put a copy of the file on each user's machine.

 

[Van T. Dinh]

Since it is a Front-End, each user should (or more correctly, must) have a
separate copy on his/her computer rather than 11 users sharing one copy of
the Front-End.

 

[Tony Toews]

I have an MDB shared on our network by approx. 11 Access
2000 and one Access XP user. It's a frontend for data on
our SQL server.

My original file compacts to 2 mb, but it seems to balloon
to 128 mb each time I put it in production use on the
network. This even happens when the file is marked read-
only!
Wierd.

Eventually the file ends up getting corrupted and I just
replace it. This will work in the short term, but what to
do otherwise???

However you really want to put the FE on each machine or place in a
user specific directory on the server. This will help avoid some
wierd error messages when users are changing the same forms record
source, filters and such as well as corruptions.

I specifically created the Auto FE Updater utility so that I could
make changes to the FE MDE as often as I wanted and be quite confident
that the next time someone went to run the app that it would pull in
the latest version. For more info on the errors or the utillity see
the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

In a Terminal Server or Citrix environment the Auto FE Updater now
supports creating a directory named after the user on a server. Given
a choice put the FE on the Citrix server to reduce network traffic and
to avoid having to load objects over the network which can be somewhat
sluggish.

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