Thanks for all your comments. I think as I just need to update the DB format and I have no CFAdmin access, and the server has CF 4.5.2 installed, I will simply run a query to do so. Not sure why I didn't think of that one myself!
Thanks again guys, - Phil. > -----Original Message----- > From: Aidan Whitehall [mailto:[EMAIL PROTECTED] > Sent: 30 June 2004 15:12 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Access .ldb files > > > > I have a project that uses Access databases and have come across a > problem. There > > is .ldb file on the server and I now cannot > > update the database, how are these lock files created, I know when you > open a .mdb > > file one is created, is one created when the db > > is accessed? How do I delete one, I only have FTP access. > > Run a query against the database that will throw an error -- it's the > old tried-and-tested method that usually works. > > <cfquery datasource="..."> > select nothing > from rubbish > </cfquery> > > In highly trafficked sites, you might find that the .ldb file gets > recreated before you get a chance to reupload the new database, so what > I used to do (back in the bad ole days of Access) was > > - upload the new database using a different name to the same folder as > the existing database > - run a page that executes your garbage query and then uses cffile to > immediately delete your old .mdb and rename your fresh .mdb > > > -- > Aidan Whitehall [EMAIL PROTECTED] > Macromedia ColdFusion Developer > Fairbanks Environmental +44 (0)1695 51775 > > ________________________________________________________________________ > This e-mail has been scanned for all viruses by Star Internet. The > service is powered by MessageLabs. For more information on a proactive > anti-virus service working around the clock, around the globe, visit: > http://www.star.net.uk > ________________________________________________________________________ > > -- > These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.712 / Virus Database: 468 - Release Date: 27/06/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.712 / Virus Database: 468 - Release Date: 27/06/2004 -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
