From: "Adrian Cesana" <[EMAIL PROTECTED]>
Subject: RE: Automatic repair and compact
> An alternate method if you dont have DAO/ADO available is to CF_EXECUTE (or
> CFX_CONSOLECOMMAND) a batch file with this in it:
>
> d:\path_to_msaccess\msaccess e:\data\mydata.mdb /repair
> d:\path_to_msaccess\msaccess e:\data\mydata.mdb /compact
This assumes Access is installed on the server - not necessarily
a good idea ....
Also - if you have Access installed you have DAO/ADO and if
you remove Access, I believe DAO will stay installed. I don't
know of any way to install DAO independently of Access.
>
> You could also easily schedule this as well using AT. I think in Access
> 2000 the compact also does the repair as well.
Yes.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
