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