I have built some admin forms for inserting records and updating records. It works fine on my server but when moved to client's server, it gives this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
----------------
I asked them update all ODBC drivers, MDAC 2.6 and Jet updates, but still get the error. Does anyone have any help on this?

Lewis Smith

Maybe your DB file doesn't have right (read/write) permissions.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I have built some admin forms for inserting records and updating records. It works fine on my server but when moved to client's server, it gives this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
----------------
I asked them update all ODBC drivers, MDAC 2.6 and Jet updates, but still get the error. Does anyone have any help on this?

Lewis Smith
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>