Thanks Ric and Tiffany, and others who responded. Problem now solved.
+++++++++
Kevin Parker
Service and Communication
WorkCover Corporation
[EMAIL PROTECTED]
www.workcover.com
ph: +61 8 82332548
fax: +61 8 82332000
mob: 0418 800 287
++++++++++
-----Original Message-----
From: Ric Smith [mailto:[EMAIL PROTECTED]]
Sent: Monday, 8 May 2000 11:11 PM
To: [EMAIL PROTECTED]
Subject: Re: Locking
Just create a query and reference a table or column that doesn't
exist in your datasource.
<cfquery name="junk" datasource="myDatasource">
SELECT JunkColumn
FROM JunkTable
</cfquery>
-- Ric Smith
> Thank you Tiffany - any chance you could e-mail the code to me as a
sample.
>
> (Sorry if you've already received this - our mail server has been down for
> maintenance for you know what)
>
>
> +++++++++
> Kevin Parker
> Service and Communication
> WorkCover Corporation
>
> [EMAIL PROTECTED]
> www.workcover.com
>
> ph: +61 8 82332548
> fax: +61 8 82332000
> mob: 0418 800 287
>
> ++++++++++
>
>
> If you cause an error the server will break its connection to the
> database and cause it to "unlock" so you can reupload the DB.
>
> I have a file called error.cfm with false code and the datasource name of
> the database I want to update..
>
> Hope that was helpful,
> -Tiffany
>
>
>
> > Can someone point me to some answers on this problem please.
> >
> > On occasions I have a problem deleting or overwriting our mdb file on
> our CF
> > space when I make some changes to database structure etc. I believe
> this
> > could be due to database locking - does this sound right and is there a
> > solution.
> >
> > I believe its also possible to make table changes (add fields, remove
> > fields, add tables etc) with SQL but someone suggested that Access
> needed to
> > support DDL to do this. Any clues please.
> >
> >
> > +++++++++
> > Kevin Parker
> > Service and Communication
> > WorkCover Corporation
> >
> > [EMAIL PROTECTED]
> > www.workcover.com
> >
> > ph: +61 8 82332548
> > fax: +61 8 82332000
> > mob: 0418 800 287
> >
> > ++++++++++
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
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.
****************************************************************************
This e-mail is intended for the use of the addressee only. It may contain
information that is protected by legislated confidentiality and/or is
legally privileged. If you are not the intended recipient you are prohibited
from disseminating, distributing or copying this e-mail. Any opinion
expressed in this e-mail may not necessarily be that of the WorkCover
Corporation of South Australia. Although precautions have been taken, the
sender cannot warrant that this e-mail or any files transmitted with it are
free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any copies.
****************************************************************************
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
