Error :80004005 file already in use

[ray436]

Help!<br><br>Our web site uses asp to run a database, for some reason we now get the 80004005 file in use error when the following piece of the script runs:<br><br>Conn.Open DataSource2<br><br>where <br><br>DataSource2=&quot;Driver={Microsoft Acces Driver (*.mdb));DBQ=&quot; & Server.MapPath(&quot;foldername/filename.mdb&quot & &quot;;&quot;<br><br>it looks OK to me but it ain't.<br><br>is it a permission problem?&nbsp;&nbsp;the file has r/w/x and Change set, so i don't understand.......<br><br>Help!

 

[Guest_imported]

Maybe, you just have your database open.So, close it and try again

 

[palbano]

&gt; is it a permission problem?&nbsp;&nbsp;the file has r/w/x and Change set, so i don't understand.......<br><br>What about the folder permissions? Access files create that .ldb or whatever file so the user needs write access to the folder as well.<br><br>-pete

 

[ray436]

thanks&nbsp;&nbsp;guestg & palbano,<br><br>the folder permissions are OK, forgot to say so.<br><br>i spoke to the ISP sys admin and he suggested re-uploading the DB, saying sometimes the permissions dont stay, especially if a user does a &quot;dirty-close or error&quot; by having their PC lock-up mid session.<br><br>did re-up, it works now, for some reason when u upload a DB the permissions dont stay, and AllowChange is usually the first to go.<br><br>No-body seems to know why......or do they..... ?&nbsp;&nbsp;&nbsp;<br>