We have an intranet running on windows 2k sp4 with iis5. the intranet was
working fine before but one day,
after we installed Software Update Services with Sp1, we got the error
message on our asp page if we have the
access file opened by access program (Before, we could open the access file,
open tables, run the
asp page to do some updates, check the updates of those tables in access
program).
Error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file
already in use.
/IntraNet/mgmtJobList.asp, line 17
I just opened the access file not even open any table and i got this error
message. However,
if i closed the access program, the ASP page will work fine, any idea? I did
set iuser_<machinename> with read/write
access to the folder and access file. Thanks!

Signature
--------------
Please remove NO2SPalphaM from my email address before reply. Sorry for any
inconvience caused.
Ron Hinds - 19 Apr 2004 23:29 GMT
> We have an intranet running on windows 2k sp4 with iis5. the intranet was
> working fine before but one day,
[quoted text clipped - 17 lines]
> set iuser_<machinename> with read/write
> access to the folder and access file. Thanks!
IUSR_machinename also needs Create priveleges in that folder. Otherwise, it
cannot create the .LDB (database locking file) in that folder.