Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Posts
    15

    Unanswered: Compacting a database through code

    Is it possible to write some code that will automatically trigger at a certain time and compact a database. I was thinking of putting this in a database we are using daily so that it would compact itself if left on at night.

    Thanks

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    FMS Total Visual Agent does what you need.
    http://www.fmsinc.com/products/agent/index.html

    or see link:

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;q158937

    or see another link

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

    HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •