Compact and Repiar

[David W]

Refering to the frontend application, do you use compact on close and does
it function after converting it to an mde?

 

[Arvin Meyer]

Some of my applications use compact on close, and some download a new
version from the server when started. I use a starting utility:

http://www.datastrat.com/Download/Starter.zip

to do the downloading. Compact on Close works in an MDE.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

yes and yes

 

[Jeff Conrad]

in message:

Referring to the frontend application, do you use compact on close and does
it function after converting it to an mde?

In addition to the other comments already mentioned, I should
probably point out that in *most* situations it is not really necessary
to be compacting the FE after every time it is opened, especially
being an MDE file. Since the data is in the BE, any bloat that should
naturally be occurring would be on the BE, not the FE. If you
are using a lot of temporary tables in the FE consider moving those
to a temporary database.