normally it will unlock after a short time, so you leaving for an hour was
the reason it unlocked and not the bogus query itself...
Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]
(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487 aim: lv2bounce
http://www.cs.odu.edu/~bader
-----Original Message-----
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 12, 2001 11:25 AM
To: CF-Talk
Subject: RE: Unlocking Access database under CF 4.5
> I have checked the CF archives looking for unlocking an
> access database. I
> found that issuing an invalid query against the datasource
> will release the
> lock. I have tried this under my current ISP, but no go. Is
> there anything
> different under CF4.5?
There have been a few times when running the bogus query didn't work, but I
just left it an hour or so, ran it again and the lockfile was deleted.
Don't think the fact that they're running 4.5 will make any difference (but
correct me people if that's wrong).
--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
