Also, file locks will prevent the compacting from happening, unless you just
happen to hit it when the web server has no locks on the database. In turn,
while you're compacting, you'll then prevent all access to the database,
including from your web site.
Jim
-----Original Message-----
From: Jason <[EMAIL PROTECTED]>
To: CF-Server <[EMAIL PROTECTED]>
Date: Monday, March 19, 2001 9:10 PM
Subject: RE: repair and compact DBs
>Yes you would have to have Access installed on the server or on a another
>machine in the domain and then share the drive across so that you could call
>it. Its been a while since Iv'e worked with Access - Im too spoiled by MS
>SQL :)
>
>Make note too that you could write a script and pass it varibles for all
>your different database items.
>You could use the custom Tag CFX_SHELLEXEC and pass it parameters for each
>DB from within your CFM pages and automate most of the process.
>Sending a variable like (d:\inetpub\odbcsources\AccessDB.mdb)
>
>C:\Progra~1\Micros~1\Office\MSACCESS.EXE %1 /compact %1
>-----Original Message-----
>From: John Cesta - Lists [mailto:[EMAIL PROTECTED]]
>Sent: Monday, March 19, 2001 7:07 PM
>To: CF-Server
>Subject: RE: repair and compact DBs
>
>
>> C:\Progra~1\Micros~1\Office\MSACCESS.EXE
>> d:\inetpub\odbcsources\AccessDB.mdb
>> /compact d:\inetpub\odbcsources\AccessDB.mdb
>
>Thanks Jason,
>
>I guess this assumes that we have MS Access installed on the server. Am I
>correct? We don't have Access installed on the server.
>
>> -----Original Message-----
>> From: Jason [mailto:[EMAIL PROTECTED]]
>> Sent: Monday, March 19, 2001 9:39 PM
>> To: CF-Server
>> Subject: RE: repair and compact DBs
>>
>>
>> I think you should be able to build a batch file using the following
>> example - obviously this depends on where your stuff is installed.
>>
>> C:\Progra~1\Micros~1\Office\MSACCESS.EXE
>> d:\inetpub\odbcsources\AccessDB.mdb
>> /compact d:\inetpub\odbcsources\AccessDB.mdb
>>
>> -----Original Message-----
>> From: John Cesta - Lists [mailto:[EMAIL PROTECTED]]
>> Sent: Monday, March 19, 2001 6:20 PM
>> To: CF-Server
>> Subject: repair and compact DBs
>>
>>
>>
>>
>> Does anyone know of a program that can repair and compact ODBC Access
>> databases from the command line?
>>
>> Maybe it would take the DB as an argument and repair and compact it.
>>
>> John Cesta
>>
>>
>>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
