These are the things I tried:
- the webserver environment needs "write" permission to the directory where the Access database resides. So, set permissions first. Go to Windows Explorer, Tools, Folder Options, View and turn off the very last entry in the list ("Use simple file sharing") if you haven't already done so.
- When you right-click on the database folder there is a "Security" tab . Make sure you give write permission to the folder with the Access database to the "IUSR_****" account (with *** being your computer's name). This account is used by IIS, as default, to evaluate permissions for the default access to your local website and scripts.
- Give the same user IUSR_
(or whatever is the default account) access to the TEMP directory of Windows. MS Access might need to write some stuff there.
Give the same account write permission in MS Access itself. These permissions can be reset by Access if you compact and repair the database so keep in mind to refresh this permission if necessary.
- If you still get the error "[Microsoft][ODBC Microsoft Access Driver]General error Unable to openregistry key 'Temporary (volatile) Jet DSN for process", check that the database is really in the directory referenced by the DSN or the connection string in your ASP file! Also, check for misspellings in the file name and whether the path is correct. This was the reason for my error today.