Thanks Adrian Cesana and Pan for all of your mails
..Its has been really helpful to me.
I have a question ,Pan you have written in one of your
mails that its better to compact and repair the
database manually rather then using CF programm.Can
you please tell me why yoyu said so.
Shally
--- pan <[EMAIL PROTECTED]> wrote:
>
> > Thanks for the code you sent> But as I am new to
> all
> > this I would like to know that do I have to
> <cfset>
> > the "objectMDB" and "tempmdb".I am failing to
> > understand your programm please help/.
>
>
> O.K.
>
> I'll try to be more helpful.
>
> objectMDB is the access .mdb file you wish to
> compact and repair. The value of the variable is the
> full path to the .mdb file, e.g.
> c:\db\thisAccessFile.mdb
>
> tempMDB is likewise a full path for the
> DAO code to use when creating the
> compacted and repaired copy of objectMDB,
> e.g.
> c:\db\tempFile.mdb
> tempFile.mdb doesn't exist until the DAO call
> and will be renamed later by your code.
>
> The method the DAO call follows is to
> create a new copy of the file you wish to
> compact and repair. It is up to you to rename
> the tempMDB to your original filename after
> deleting the objectMDB.
>
> The call to the CF function
> <cfset dropConnections =
> CFUSION_DBCONNECTIONS_FLUSH()>
> is necessary as the cffile delete and rename actions
> will
> fail if the the .mdb is locked (i.e in use).
>
> In order to correctly assign the value of daoClass,
> look in
> c:\Program Files\Common Files\Microsoft Shared\DAO\
>
> You should see either dao360.dll or dao350.dll
> depending on
> if you have Access2k or Access97 respectively.
>
> Advice:
> If you are going to schedule this, pick a time when
> it is less likely the db is going to be in use as
> CFUSION_DBCONNECTIONS_FLUSH() call
> might interrupt a user session. I prefer to use a
> tool
> I built to manually compress and repair any .mdb
> files
> I happen to be using.
>
> If you have any more questions, please feel free to
> ask.
>
> Pan
>
>
>
> > >
> > > 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.
> > >
> > > The below script is the safest way I use.
> > > You should wrap the below in a cftry/cfcatch
> trap.
> > >
> > > core script: modfy to your needs
> > > <cfset daoClass="DAO.DBEngine.36">
> > > or,
> > > <cfset daoClass="DAO.DBEngine.35">
> > >
> > >
> > > <CFOBJECT Action="create" name="DBEngine"
> > > Class="#daoClass#">
> > > <CFSET dummy=
> > >
> DBEngine.CompactDatabase("#objectMDB#","#tempMDB#")>
> > > <cfset dropConnections =
> > > CFUSION_DBCONNECTIONS_FLUSH()>
> > > <cffile action="delete"
> > > file="#objectMDB#">
> > > <cffile action="rename"
> > > source="#tempMDB#"
> > > destination="#objectMDB#">
> > >
> > > Pan
> > >
> > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
