compacting: back end and front end together?

J

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?
 
A

Arvin Meyer

John Milbury-Steen said:
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?
Click to expand...

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
 
Top