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.
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
