Hi, hope someone can help,

Not sure if there is a problem with my Dreamweaver 8 setup or not but I'm running an asp site and maintaining through Dreamweaver. Any time I access a database through the database control panel in DW8 a permanent database lock file is created in my localhost root folder meaning I cannot test my pages on my testing server as the database is locked. I understand that if the databse is open, a lock file is created and I cannot access pages that use the DB but even when I close the DB in the databases panel, the lock file persists. The only way to remove this lock file is to close down Dreamweaver. I'm using an Access database and opening the database directly creates a lock file which then disappears when closed. The persistent lock file only occurs when opening the DB through Dreamweaver.

I can't find any information on this anywhere, can someone please help???

Thanks,

Maureen.

Try changing the permisions on the file. Give the Internet Guest Account user full control over this file... The lock file will still be created, but it will allow you to access the DB file with your asp script simultaneously.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Try changing the permisions on the file. Give the Internet Guest Account user full control over this file... The lock file will still be created, but it will allow you to access the DB file with your asp script simultaneously.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Hi there,

Thanks for your advice but I've checked the permissions on the access file and these seem ok (not read-only anyway). I've also ammended the Internet Guest Account to give it administrator permissions which seems to be the highest level as it gives unrestricted access but the lock file still persists after the database is opened and closed in Dreamweaver.

Any other help and advice would be greatly appreciated.

Maureen.

Just out of curiosity, are you using simple file sharing? I would recommend turning that off. You have much more control with it turned off. Once you have it turned off, goto the the properties of the file and then goto the security tab and give the Internet Guest Account Full Access.

Edited by - flexman44 on 30 Jan 2007 22:46:51

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Just out of curiosity, are you using simple file sharing? I would recommend turning that off. You have much more control with it turned off. Once you have it turned off, goto the the properties of the file and then goto the security tab and give the Internet Guest Account Full Access.

Edited by - flexman44 on 30 Jan 2007 22:46:51
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Hi again,

Turned off file sharing as suggested and was able to give the Internet Guest Account full access via the security tab, but again the lock file persists when the database has been opened and closed in Dreamweaver. I then gave the account full access to all folders above the file and the entire drive in which it is contained but still no luck. Is there anything else I can try???

Thanks for all your help, it's much appreciated.