-----Original Message-----
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 12:36 PM
To: CF-Talk
Subject: Re: Locked Database
>I'd advise against this usage. Performing invalid queries isn't the
>preferred method. Using the CFusion_DBConnections_Flush() function is a
>much more stable way to unlock an Access database.
What is the reason for not doing the former? The latter will disrupt all datasources
on the machine -- not a desired result by any means, although if his datasource is the
only one, then I don't see why it matters. Since both break the connection, what are
the reasons behind not using the first method?
-Andy
At 10:32 PM 08/06/2001 -0400, you wrote:
>The simplest way is to make a bogus call to the database that will
>definately produce an error (such as a call to a table or column that
>doesn't exist). That will cause the Access engine to drop connections to
>the database and will unlock it. There is a way that works for databases
>besides Access, but that should do what you want :)
>
>Todd
>
>----- Original Message -----
>From: "CFHelp" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, August 06, 2001 10:11 PM
>Subject: Locked Database
>
>
> > Is there some code I can put into a page to unlock an access database?
> >
> >
> > Rick Eidson
> > Owner
> > http://www.kchost.net/
> > KChost is getting ready to launch it's enews service
> > Now you can moderate your own affordable newsletter
> > Promote you products and services even sell advertising. Plans start at
> > $5 a month for 500 emails. FREE Trial account.
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
