The good 'ole bad query approach doesn't always work these days. I haven't investigated it enough to see if it's the ISP's setup, or Access 2000 that is to blame. All I can say is that I used to use this approach all the time and it doesn't work anymore.
my 2 cents Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Larry Juncker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 9:01 AM Subject: RE: Script to release lock on an Access database > Just write a query to a bogus table in your DSN and it will break the lock > ie: > > <cfquery name="killDSNConnect" dataource="[YourDSN]"> > SELECT * > FROM NOTHING > </cfquery> > > > -----Original Message----- > From: Terry [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 07, 2003 10:30 AM > To: CF-Talk > Subject: Re: Script to release lock on an Access database > > > Here's what I do: Upload new db with a different name, then rename. > > *********** REPLY SEPARATOR *********** > > On 2/7/2003 at 11:16 AM Phillip Cave wrote: > > >It's be awhile since I've used MS Access as the database for a web > >application, so I'm not sure this question is even relevant for CF5 or MX. > > > >Is there a script out there that will release the lock that put on an > >Access > >database once a data source has been setup? We've got a client who > >constantly updates an access database with new fields/tables etc. I seem to > >remember that you couldn't just FTP the new database to the server because > >of the lock. We're not giving this guy CF Admin access because the box is a > >shared hosting environment. > > > >Any ideas are appreciated. That particular server is CF5 btw. > > > >Thanks, > > > >Phillip > > > >.................................... > >Phillip Cave > >ColdFusion Developer > >Carol/Trevelyan Strategy Group > >202.448.5212 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
