compact linked files 1

[MikeGK]

I have an access db that is split: The queries, forms, macros and modules are in one file (say the program db) and the tables are linked tables from another db (say the data db).
When I compact the program db are the tables in the data db compacted also or do I have to open the data db to compact it?

 

[tlbroadbent]

You'll need to compact the backend separately. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[MikeGK]

So, which part of the two really needs to be compacted; the front-end or the back-end? In other words is the front-end getting "fragmented" also, or only the data in the back-end get "fragmented" and need compacting?

 

[tlbroadbent]

Usually the back-end has the most activity because that is where the data is. So it is most critical to compact the back-end. However, you'll note growth in the front-end DB even if there are no changes to objects and no data. Although usually not as critical, the front-end compact can still prove helpful. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.