On Thu, May 15, 2008 at 7:54 AM, Ottavio Campana <ottavio@xxxxxxxxxxxxx> wrote: > I know it's not fully IT with the list, but maybe somebody can help me. > > I'm dealing with this scenario: access 97 is connected through odbc to a > postgresql server. All tables are saved in postgresql and access is used > only to generated the program interface. > > Everything works fines, but I'm having problems with the serial data type. I > know a serial is an integer having as default the next value of a sequence. > Since it is an integer, access does not recognize it as an autoincrement > value, and it asks for is value. > > Did anyone of you already have this problem? Can you feed it a value of DEFAULT???