Error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
Reason1 : ODBC Connection (OLD FASHION)strConn = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=E:\ABC\XYZ.mdb"
Solution: OLEDB Connection
strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=E:\ABC\XYZ.mdb;" & _
"User Id=<username>;Password=<password>"
note: specify username and password if any
-----------------------------------------------------------------------------
Reason2 : RIGHTS
Access Rights (Write Permission) is not given to that folder / file (for e.g. ABC)
Solution:
Give Rights of "Write Permission" to Internet Guest Account (IUSR_<MachineName>)
-----------------------------------------------------------------------------
Reason3 : MDB file is read only
Solution:
Remove Read only attributes of file.
(hint: Right Click on File->Properties->Un check Read Only->Apply->OK)
-----------------------------------------------------------------------------
Reason4 : Problem executing Query
Query is not updateable sometimes when using relational tables improperly.
Solution:
Look into Query and Update query according to satisfaction.
