Ever seen this error "Operation must use an updateable query" when trying to add, update or delete when using ASP and Microsoft Access on your web? How do I get rid of it? Here is your answer... The IUSR_MACHINENAME account which is used by IIS when accessing webpages and directory's has to be able create the .ldb file. This is a file Access creates on the fly when its opened.
Without getting into a full discussion on NT security and all it involves. Just make sure the IUSR_MACHINENAME account has at least change permissions on the particular directory the database resides in so data can be inserted to it.. By default the IUSR_MACHINENAME account is only given Read, Execute permissions. You'll only see this error when using the NTFS file system. This is the most secure file system available on NT. If your unsure how to do this consult your web admin!
Dynamic Sitemap and Navigation in ASP.Net
