database increasing in size exponentially

[Marcia Schulman]

I am working with a database thats 16 meg when
compressed. It's on a network with 3 users. After using
it for about 2 hours it increases in size to 586 meg!
Does anyone have any idea how I can remedy this problem?

 

[Guest]

How do I split it into front end & back end?
I do have an image stored that is used as a header in all
the forms. Could that be causing a problem?
Everyone is working with the same file via a shortcut. Is
there an alternative?

 

[Tony Toews]

I am working with a database thats 16 meg when
compressed. It's on a network with 3 users. After using
it for about 2 hours it increases in size to 586 meg!
Does anyone have any idea how I can remedy this problem?

In addition to the splitting suggestions, which I'd do first. you may
have different Jet versions on computers. Compare the version of
msjet40.dll on the systems.

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

 

[John Vinson]

How do I split it into front end & back end?

Tools... Database Utilities... Database Splitter. This will create a
new database (with _BE appended to the name of your current database)
containing just the Tables; everything else will remain in the
"frontend" database, linked to the tables. Each user should have a
separate copy of this frontend on their own machine.

I do have an image stored that is used as a header in all
the forms. Could that be causing a problem?

Yes. Access is LOUSY at handling images. If you must do this, keep the
image as small as possible and embed it in the form, rather than
loading it when you open the form.

Everyone is working with the same file via a shortcut. Is
there an alternative?

Yes, the split database above - MUCH preferred.