With ldbview.exe you can see who is locking the database. http://www.samroach.com/ldbview.exe
This may or may not help. -- Sam -----Original Message----- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 7:40 AM To: CF-Talk Subject: RE: access db Yes, can open tables but changes will not be reflected because I don't have exclusive access to it because of the ldb. -----Original Message----- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:14 AM To: CF-Talk Subject: RE: access db Did you run a repair and compact on the database. Is it the whole database or maybe one corrupt table? can you open the tables individually? I've seen lots of access databases where one table corrupts but it looks like the whole thing is whacked out. -----Original Message----- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:56 AM 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 > > > > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
