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