What you are doing does not neccessarily require downloading the db - you
could execute some SQL to achieve the same...
ALTER TABLE Users ALTER COLUMN FieldIWantToAlter TEXT(255)
also, there is an (undocumented) CF function that unlocks all CF datasources
on the server...
CFUSION_DBCONNECTIONS_FLUSH()
This in mty experience works more reliably than the other method mentioned -
but may have potenetial performance issues if you have other ds's on the
same server...
HTH
Dan.
-----Original Message-----
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: 05 March 2001 13:55
To: CF-Talk
Subject: Re: Freeing .ldb lock on remote server.
http://www.thenetprofits.co.uk/coldfusion/faq/#answer77
jon
-All your base belong to us!
----- Original Message -----
From: "Ang�l Stewart" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 05, 2001 8:46 AM
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
