In ColdFusion Administrator, modify every Access ODBC Datasource and set the following (you will need to click the CF Settings button to see these):

Buffer Size = 0 (ODBC only) Page Timeout = 600 (ODBC only) Uncheck Maintain Database Connections

By a show of emails, does anyone have these settings on their Access DBs?

Thanks,

John Cesta

> -----Original Message----- > From: Jim McAtee [mailto:jmcatee@mediaodyssey.com] > Sent: Tuesday, March 20, 2001 1:14 AM > To: CF-Server > Subject: Re: repair and compact DBs > > > 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 <mobile@computercu.com> > To: CF-Server <cf-server@houseoffusion.com> > 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:lists@lookwww.com] > >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:mobile@computercu.com] > >> 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:lists@lookwww.com] > >> 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 cf-server-request@houseoffusion.com with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com