Split App and Back End file size

  • Thread starter Thread starter Kyle Jedrusiak
  • Start date Start date
K

Kyle Jedrusiak

We have our app split into two physical files.

The app part accesses both SQL server and it's own back end data using
linked tables.

The back end file seems to grow at a reasonable rate.

However, the app file grows to about 30 times its size based on its size
when compacted/repaired.

Why is this happening and is it normal?


Kyle!
 
We have our app split into two physical files.
The app part accesses both SQL server and it's own back end data using
linked tables.

The back end file seems to grow at a reasonable rate.

However, the app file grows to about 30 times its size based on its size
when compacted/repaired.

Why is this happening and is it normal?
Click to expand...

Some bloating is to be expected, but sometimes there are issues that cause
excessive bloating. An excellent source of information on this subject can be
found on the following page at Tony Toews' web site:

Bloating Front End (FE) Microsoft Access MDB/MDEs
http://www.granite.ab.ca/access/bloatfe.htm
 
Back
Top