In order to use Microsoft Access through ASP, you must give the file/folder write permissions if you wish to update the database.

If you choose to use Microsoft Access for your database for use with Ultimate Survey Professional survey software, the anonymous IIS user must have WRITE permission to the Access file. (.mdb)

Here are example errors that may be displayed when this permission is not set:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x6f8 Thread 0x5ec DBC 0x224603c Jet'.

OR

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

To set this permission:

1. In windows explorer, browse to the parent folder of the folder containing your Access file.

2. Right click on the folder containing the Access file.

3. Click on properties

4. Click the security tab

5. Click "Add"

6. Add the "Internet Guest Account"

7. Make sure "Read and Execute", "Read", and "Write" are all checked for this user.