Query a table that doesn't exist. It will unlock the database:
<CFQUERY DATASOURCE="#DSN#">
SELECT *
FROM FourScoreAndSevenYearsAgo
</CFQUERY>
That'll do it.
--Ben
At 10:09 AM 4/6/01, you wrote:
>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
