Re: MS Access / Informix connection is read-only

Howard Wittenberg wrote: > >ODBC requires that a table have a unique key if it is going to be > >updatable. > Thanks for the posting. I wish that was it. We have a number of > tables and they all have Primary Keys. What are the names of the primary keys resp. the names of the associated indexes? I remember hearing about a problem that MS Access doesn'tt recognize these primary keys or index files if their names start with a blank (or was it an underscore?) and Informix assigns such invalid names when a primary key constraint is used. The workaround is to manually create the unique index and giving it a name that Access can recognize. HTH, Richard -- +--------------------------+------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | GSM : +49-172-8933578 | +--------------------------+------------------------------------------+