compact

[Guest]

I have a macro that has few actions such as run delete query and then import
data.

The whole idea is to delete all records and import the latest ones.

however due to the large file size...the database needs to be "Compacted &
repaired" after running the delete query.

How can I addd compact & repair in the action line of the macro?

Pls help.

 

[Guest]

Check this link

http://www.mvps.org/access/general/gen0013.htm

 

[Arvin Meyer [MVP]]

Check this article on the Access Web if your database is written in Access
2000 or later:

http://www.mvps.org/access/general/gen0041.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Douglas J Steele]

Your application should be split into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relationships). The front-end can compact the back-end without
any problems.