> 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]
