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 --------------------------------------------------------------------- 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/
