that's a good technique. Presumably you could put something in the
application.cfm to redirect them to a static page with a 'site temporarily
down for maintenance' message.
Jolly Green
Giant To: <[EMAIL PROTECTED]>
<[EMAIL PROTECTED] cc:
dstoy.com> Subject: Re: [ cf-dev ] Access .ldb
files
30/06/2004
15:10
Please respond
to dev
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]
--
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]
