Compact & Repair of an Access database via a macro

[m wark]

I would like to repair and compact an Access database via
a scheduled job, rather than having to be signed on to the
server and initiate and wait for these 2 utilities to
run... Does anyone know how to set up a scheduled job to
run on a regular basis which would accomplish this?

Thanx for your help...

 

[Dennis Schmidt]

Hi ,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

The following Knowledge Base article should get you started in the right
direction.

http://support.microsoft.com/default.aspx?scid=kb;en-us;158937

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support