thanks, already tried that. I'm just going to eat the cost and make it SQL 2000.
-----Original Message----- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:05 AM To: CF-Talk Subject: RE: access db Reboot Machine, you will.... problem fix, will it. -----Original Message----- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:56 To: CF-Talk Subject: RE: access db Full access to the machine, I have. -----Original Message----- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:50 AM To: CF-Talk Subject: RE: access db You have probably tried this, but have you rebooted (do you have access to the machine)? Chuck Rodgers At 09:37 AM 8/15/02 -0400, you wrote: >P.S. Left site stopped all last night. (this is not a live site, but dev) >But still is locked. Lifes a Bitch :| > >-----Original Message----- >From: Robertson-Ravo, Neil (REC) >[mailto:[EMAIL PROTECTED]] >Sent: Thursday, August 15, 2002 9:30 AM >To: CF-Talk >Subject: RE: access db > > >ah :-) <blush/> > >That said, if none of these things unlock your file then there is something >seriously wrong...try this : > >1. Uncheck "Maintain Database Connections" within CF Admin >2. Stop CF >3. Start CF >4. Try and get file > >If that doesnt work.... >1. Stop CF >2. Stop IIS >3. Check Security Permissions on that file/directory >4. Reset them as necessary (log in as Administrator) >5. Delete .ldb file > >Let us know. > >Neil > >-----Original Message----- >From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] >Sent: 15 August 2002 14:26 >To: CF-Talk >Subject: RE: access db > > >Read my post. > >-----Original Message----- >From: Robertson-Ravo, Neil (REC) >[mailto:[EMAIL PROTECTED]] >Sent: Thursday, August 15, 2002 9:20 AM >To: CF-Talk >Subject: RE: access db > > >unlock it then! > >-----Original Message----- >From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] >Sent: 15 August 2002 14:22 >To: CF-Talk >Subject: RE: access db > > >Yes, and make the changes needed. But unless it gets unlocked a can't >replace it with the correct db. > >-----Original Message----- >From: Matthew Walker [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, August 14, 2002 6:33 PM >To: CF-Talk >Subject: RE: access db > > >can't you just take a copy of the database? > > > -----Original Message----- > > From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, 15 August 2002 7:14 a.m. > > To: CF-Talk > > Subject: access db > > > > > > I have a client today that is switching their CF site built > > with an access > > db to our servers, along with that they needed for me to > > build an upload > > function for a spreadsheet, the xls name is going to be > > stored in the db. I > > need to add that column. > > > > BUT, the darn thing is locked. Simple enough run a select query on > > non-existent table calling the data source. NO GO, will not > > unlock. Ok, try > > the db connection flush tag, NO GO. Ok, unclick maintain db > > connections in > > admin, NO GO. Ok, restart services, NO GO. I checked all > > office computers > > nobody has it open. I have stopped the website in IIS so no > > users could > > connect, NO GO. > > > > Is there any other way to unlock the database? This is one of > > the reasons I > > tried to talk the client out of access, but again NO GO. > > > > If you have any suggestions it would be greatly appreciated. > > > > Thanks > > Bryan > > > > > > > > > > ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists