<CFQUERY NAME="breakinglock" DATASOURCE="#dsn#">
SELECT NOTHING
</CFQUERY>
Bad Queries break the maintaining connection and thusly realese the lock...
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: Ang�l Stewart [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 05, 2001 8:47 AM
> To: CF-Talk
> Subject: Freeing .ldb lock on remote server.
>
>
> Hello,
>
> I am using a shared hosting system, and I want to copy and
> update a database
> stored on the server that is locked (MSACCESS .ldb).
>
> I need to increase a field in the Users table from 50 to 255
> characters.
>
> Do any of you recall the command or method to break the .ldb
> lock and so
> enable me to copy/transfer the .mdb file, do my compacting
> and updates and
> then send it back up to the server again?
>
> -Gel
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
