Classic ASP program with Access database on Windows server 2008

Got error 800a0cb3 from the Web log file at Windows Server 2008. It is IIS7. The Web application is made by ASP. Actually classic ASP, not ASP.Net.

And also with Access database.  The page is try to add new record into the Access database file. But the browser return 500 internal error. The detail error code in log file is 800a0cb3 with the description: Recordset does not support updating. This may be a limitation of the provider or of the selected locktype.

I did a lot of research and found it is a right issue.

Now it is the solution:

Add “Authenticated Users” to the Access mdb file, with full access right.

access-win2008-permission

Then, no more error, the data can be added as design.