locked
MS Access 2010 database can not open RRS feed

  • Question

  • User1185319194 posted

    I was using Classic ASP and  IIS 7.0 (Windows 2008).  I had to upgrade to IIS 8.5 (windows 2012). I am getting this consistent message. I have set maximum permission but no luck.

    Microsoft Access Database Engine error '80004005'

    The Microsoft Access database engine cannot open or write to the file 'Data.accdb'. It is already opened exclusively by another user, or you need permission to view and write its data.

    /DataUpdates/script1.asp, line 124

    strConn="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\temp\Data.accdb;Persist Security Info=False;"

    I had tried following on Windows 2010 Server

    * Installed IIS Compatibility

    * Installed ASP Role

    * Installed Microsoft Access Database Engine 2010 Redistributable from https://www.microsoft.com/en-ca/download/details.aspx?id=13255 (am i missing any adoptor)

    * Added "C:\temp\database.accdb" properties with full permission and full "app pool" permission

    * It worked on windows 2008 with "classic" app pool v2.0 (I had tried all settings and acccount)

    Could you please tell me what I am missing!!!

     

    Monday, November 13, 2017 3:02 AM

All replies

  • User-460007017 posted

    Hi ramjee,

    You could try to disable the user profiler in application pool->advanced setting->load userproifler->false. In addition, please try to grant authenticated user and application pool identity the permission read/write permission to access c:\windows\temp not C:\temp\. Secondly, please ensure the connection string is correct without any issue.  If the steps above is not working, you could try to enable 32-bit application in application pool advanced setting.

    Best Regards,

    Yuk Ding

    Tuesday, November 14, 2017 2:46 AM