The reason I think it might be your code is cos it isn't normal for this to happen, so it must be something you are doing different. The main difference between one site and the next is the code :) Of course it could be a server issue, a permissions issue etc.
One thing you might try is to download process explorer from http://www.sysinternals.com/ When you get in a locked situation fire it up and see if you can see what has a handle on the ldb file. Other than that it's a case of how you are accessing the DB I'd imagine. Unless we can see your code it would be hard to say. -----Original Message----- From: Ben Shaffer [mailto:[EMAIL PROTECTED] Sent: 01 March 2005 7:29 To: [email protected] Subject: [ASP] RE:Access Database locking buy not unlocking Although I do appreciate your answer, it would be more useful if you could guide me a bit more in what could be causing this, and why you think it could possibly be in my code.... Thanks, Ben From: Adrian Forbes - ITD <[EMAIL PROTECTED]> Date: Tue Mar 1, 2005 10:07 am Subject: RE: [ASP] RE: Access Database locking but not unlocking The problem is probably with your code somewhere. -----Original Message----- From: Ben Shaffer [mailto:[EMAIL PROTECTED] Sent: 01 March 2005 10:01 To: [email protected] Subject: [ASP] RE: Access Database locking but not unlocking For various reasons, I need to use an Access database as opposed to SQL Server on one of my sites to hold user info etc. My problem is, that every so often, it locks and doesn't unlock itself - as in the ldb file is produced and doesnt disappear. I am unable to delete either the ldb or the mdb file via ftp. When I download the file, compact and repair it and then reupload it and change the connection string to point to the new db, then everything works well until the next time. a. Is there anything I can do to avoid this happening? b. Where does the responsibility lie? eg. db, server, code etc. Thanks, Ben [Non-text portions of this message have been removed] --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links The contents of this email and any attachments are sent for the personal attention of the addressee(s) only and may be confidential. If you are not the intended addressee, any use, disclosure or copying of this email and any attachments is unauthorised - please notify the sender by return and delete the message. Any representations or commitments expressed in this email are subject to contract. ntl Group Limited --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
