Hi,
I don't have DAO installed.I was going to install
Access on my server.Can you please guide me how to use
CF_EXECUTE or CFX_CONSOLECOMMAND.So that I won't have
to install Access.
Thanks in advance
Shally
--- Adrian Cesana <[EMAIL PROTECTED]> wrote:
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists