Solution for "Operation must use an updateable query"

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.