Hi Peter,
Thanks for the response. It turned out to be a CF problem with the CF
server holding open the database. There seems to be two effective
approaches to handles this -- a Flush.cfm file executed in a browser breaks
the connection and kills the .ldb file (This works like a champ -- did you
see the code in a previous response -- if not, I'll send it too you) -- and
two, unclick the maintain connection in the CF server administrator (I
never knew that was even there).
Thanks for the help,
Dru
303 666-7665
At 12:15 10/5/2000 -0600, you wrote:
>Dru,
>
>The ldb file is used by access as well as Cold Fusion. So, if you have that
>database open in Access on your desktop, an ldb file will be present. If
>you close that database (don't have it open in Access on your desktop) the
>ldb file on your hard drive should go away.
>
>Hope that helps,
>
>Peter Janett
>
>New Media One Web Services
>================================
>WEB HOSTING FOR WEB DEVELOPERS
>================================
> -> Sun, IRIX, NT, Linux <-
>PHP, MySQL, Perl, Cold Fusion,
>MS SQL, ASP, SSI, SSL
>http://www.newmediaone.net
>[EMAIL PROTECTED]
> (303)828-9882
>
>----- Original Message -----
>From: Dru Whitledge <[EMAIL PROTECTED]>
>To: CF-Talk <[EMAIL PROTECTED]>
>Sent: Thursday, October 05, 2000 10:34 AM
>Subject: Death to .ldb !!!
>
>
>> If anyone else is working with MS Access you've probably had the same
>> annoying experience!!
>>
>> I often have to swap backed up databases (.mdb files) and if I've been
>> using the old database that I want to copy over -- there is always a damn
>> .ldb (file / record locking file) in the directory that prevents me from
>> overwriting the old database.
>>
>> I know how to cure this problem on the web (make a dummy query to a
>> nonexistent table in the same database) but that technique doe not seem to
>> work on my hard drive? I usually end up, annoyed as hell, having to
>re-boot
>> to be able to delete the damn thing off.
>>
>> Does anybody know of a simpler way to dispatch this pesky little .ldb file
>> -- without rebooting?
>>
>> Thanks,
>>
>> Dru
>> --------------------------------------------------------------------------
>----
>> Archives: http://www.mail-archive.com/[email protected]/
>> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>>
>
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
>
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
