I was in that same senario for years. my ldb's took 30 min to clear. And with only FTP, there's nothing you can do really.
There is some code that you can run to clear out all the connections and free it up, but if you are in a shared environment, it may -- will probably -- disrupt everyone else. One solution I used was to find all my references to that datasource and put some code around them that checks for a site-wide variable. if that var is false, it doens't allow the connection to the db and gives the user a 'temp out of service" error page. 30 min of that would free up my db and then I 'd do what I had to do, and then set that var back to true so that normal functions could resume. Now if you just need to do things like add fields or tables, you can do that dynamically through SQL in your query statements. You wouldn't need to bring down the db for that. __________/ Phil Ewington - 43 Plc \__________ >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. -- 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]
