Look for the ldb file- as per info below. Is there one defined?
When you open an Access database file (.mdb) in shared mode, Microsoft Access also creates a locking information file (.ldb) with the same file name (for example, Northwind.ldb) and in the same folder as the database file. This locking information file stores the computer name (such as mypc) and security name (such as Admin) of each shared user of the database. Microsoft Access uses this information to control concurrency. In most cases, Microsoft Access automatically deletes the locking information file when the last user closes the database file. -----Original Message----- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:37 AM To: CF-Talk Subject: RE: access db 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 > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
