Can you have Access backend open and still access ASP

[rossmcl]

I get the message below when try to access ASP and the Access backend is open.<br><br>Is there anyway of getting round this (is it specific to Access or would I get teh same if I was using sybase back end?<br><br>Thanks as Always<br>Ross<br><br><br>Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br><br>[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use. <br><br>/cgi-bin/test/rmclanac/paging3.asp, line 82 <br>

 

[NickBulka]

Ross,<br>&nbsp;&nbsp;&nbsp;You should be able to open an Access database multiple times concurrently.&nbsp;&nbsp;Make sure you're not opening it exclusively.<br> <p>nick bulka<br><a href=mailto: > </a><br><a href= > </a><br>

 

[rossmcl]

Nick (et al)<br>I dont think it is this. The db is set to open shared and not exclusive in tools&gt;options in the db. (no record locking)<br><br>Its not the end of the world, but it would be nice for the administrators to be able to run reports in the background whilst uers are using the web front end. Almost certainly this is possible, anyone else have any suggestions.<br><br>Much appreciated<br>Ross

 

[palbano]

Dear Ross,<br><br>What server are you using?<br><br>If you are running a real installation of IIS on NT Server then you are probably running into a permissions problem. The access files like to write to a temporary file of the same name as the .MDB but with a .LDB extension. The IUSER_XXXXX account being used by the web server needs to have write access to the folder where the database file resides. The Web server must also be set to 'write' permission for that folder.<br><br><br>Hope this helps,<br>Pete<br>

 

[rpet]

hi ross!<br><br>take a look at this:<br><br><A HREF="

http://support.microsoft.com/support/kb/articles/Q174/9/43.ASP"

TARGET="_new">

http://support.microsoft.com/support/kb/articles/Q174/9/43.ASP</A><br><br>.ralf<br><br>