I have a web page that updates an access database. A few months ago I deleted the directory and had to restore it from a back up server. Since then I am the only one that can make updates to the database. Anyone can view the contents of the database via .asp pages, but when it comes to updating this database I seem to be the only one.
We have checked the settings on the IIS sever as well as the permissions, but to no avail.
Help!!!
The error is: Micrsoft OLE DB Provider for ODBC Drivers error ‘80004005’
[Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an updateable query.
PS I Googled the error and followed some of the fix suggested but still no access.