Before doing this, you will need to make sure no one else
would be attempting to write data to the database.
Just do a simply Query that causes an error with
the database.
<CFQUERY NAME="KILLLDB" DATASOURCE="#application.DSN#">
Select * From NOTABLE
</CFQUERY>
Make sure that this Datasource is correct and the table
name you specify in the query does NOT exist.
This will kill the LDB locking file.
-----Original Message-----
From: Erika Foster [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 06, 2001 11:10 AM
To: CF-Talk
Subject: Breaking Datasource Connection
I know, I know - this has been asked a trillion times.
I need to upload a brand new copy of the access database, but 'its in use by
another processs' so of course the upload fails.
How do I break the connection so I can upload the updated database?
Thanks.
Erika Foster
engineering-environmental Management
Applications Developer
(505) 866-1654
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
