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
You could also easily schedule this as well using AT. I think in Access
2000 the compact also does the repair as well. There are other command line
options as well like /exlu (I think thats it) that opens in Exclusive mode
etc...Do a search in Access help on "Command Line" for more.
Hope it helps,
Adrian
-----Original Message-----
From: pan [mailto:[EMAIL PROTECTED]]
From: "monika kon" <[EMAIL PROTECTED]>
Subject: Automatic repair and compact
> Hi everyone,
> Is it possible to compact and repair Access databbase
> every day automatically through Coldfusion code.Please
> help!!
> Shally..
Yes.
Acc97 DAO 3.5
Acc2k DAO 3.6
DAO needs to be on the server - there are ADO
calls, but DAO seems better to me.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
