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
