Split App and Back End file size

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!
 
B

Bruce M. Thompson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exuberant database file size increase 5
Synchronization problems while moving folders to new email 1
looking for a way to unlock a back end mdb file 16
SQL Server Backend: linked tables or no more bound forms ? 4
Vista explorer can write to network folder but app can't? 1
Problem with MS Word paragraph and character styles: format getting messed up 2
File Structure and Performance 5
Back end memory size 3

Top