compacting: back end and front end together?

[John Milbury-Steen]

Hi Access gurus,
In a split applicaiton, when you compact the front end (the queries and
form and reports), does the back end (the tables to which you are linked)
compact, too? Or are you supposed to compact the back end separately?

 

[Arvin Meyer]

Hi Access gurus,
In a split applicaiton, when you compact the front end (the queries and
form and reports), does the back end (the tables to which you are linked)
compact, too? Or are you supposed to compact the back end separately?

You need to compact the back-end separately. Actually, it is far more
important to compavt the back-end as that is where the data is. Compacting
the front-end decompiles the queries (which is a good thing to do
occasionally, but it is not as necessary as cleaning up the back-end).
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access