Compacting a database

[Dbless]

I have split my database into a frontend/backend database.

Can I or how do I create a macro that I can execute from a scheduler to compact the database automatically at a particular time of the day without creating another database to compact it?

Thanks in advance.

 

[jbehrne]

Hi,

To compact the database try this link:

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

It will provide code to compact the db from code
To schedule the compacting of the db go to this link and click on "Scheduler":

http://www.mvps.org/access/resources/downloads.htm

These two combined should fix your problem.

HTH,

jbehrne