Re: MS ACCSS wierd problem..

From: "Sinha, Niraj" <niraj.sinha@BondBook.com> > >I am having problem in updating one of our tables through MSACCSS. >Let us say that the table name is ACCOUNT and the schema is : > >accountnum serial not null, >firmnum integer not null, >accountname char(10) not null, >. >. >. >. >.. >) > >Now when I go to update the accountname which is a char data type, >I get the following error : > >ODBC --call failed >[Informix][Informix ODBC Driver][Informix]A SERIAL column (accountnum) >may not be updated (#232) > >This is driving us crazy. I am trying to updae char data type, and due >to some reason it is updating the serial data type. >This is not through any MSACCSS designed form. This is just adfter >linking the table and trying to update. > >Any ideas ??? If you look at the generated SQL, you'll prolly see that Access is saying something like: UPDATE account SET accountnum = X, firmnum = Y,accountname = Z ... _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com