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

Reply via email to