Help! Error 80004005 file already in use 1

[ray436]

Hi everyone-&nbsp;&nbsp;<br><br>Our website was working but now we get an 80004005, file already in use error when the script :<br><br>Conn.Open DataSource2 <br><br>is run, this is defined as:<br><br>&lt;%DataSource2=&quot;Driver={Microsoft Access Driver (*.mdb));DBQ=&quot; & Server.MapPath(&quot;thefolder/thename.mdb&quot&&quot;;&quot;%&gt;<br><br>i cant figure why the connection fails----- is it a permission issue on the server ?<br><br>the folder and filename are right, is there a limit to filename length?<br><br>i had the ISP set read/write/execute/allowchange on the file, but it still wont run.......<br>

 

[desiboy]

read this article:<br><A HREF="

http://support.microsoft.com/support/kb/articles/Q183/0/60.ASP"

TARGET="_new">

http://support.microsoft.com/support/kb/articles/Q183/0/60.ASP</A>

<p>Sandeep Anand<br><a href=mailto:sandeep@matatechnologies.com>sandeep@matatechnologies.com</a><br><a href=

http://www.matatechnologies.com>Mata

Technologies</a><br>sign up for our free Discussion list: "Access Tips And Tricks" at

http://www.matatechnologies.com

 

[ray436]

thanks desiboy;

the article did identify the error, funny thing is tho- the error is not supposed to happen; ie this DB should maintain the permissions after transfer to th e-server.

Apparently the &quot;fix&quot; is to upload the DB, then get the sys-admin to reset the properties, mainly &quot;change.&quot;

Several people I have spoke to have seen it also, and the easiest thing to do is just upload, set permissions, then upload again - the permissions seem to stick after the first time (?)

aaahhhh Microsoft.