Angel, there's a tutorial on this at www.teamallaire.com/tutorials.
Basically, you run a query that throws an error and the lock will be
released.
Hal Helms
Team Allaire
[ See ColdFusionTraining.com for info on "Best Practices with ColdFusion &
Fusebox" training ]
-----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