Re: MS Access / Informix connection is read-only

In article <352d9944.0@news1.ibm.net>, hwittenb@pacbell.net says... > >In article <35238a40.21910312@gate.idg.no>, Nils.Myklebust@nmdata.com says... >> > >>>The Unique Indexes would have been a work-around for the problem. When you >>>attach the table(s), Access asks you to specify the Unique Index field and if >>>you select a field, then the table is also updatable. >> >>Yes, but that is definitely not the way to do it. Here is what you do >>in your database (Informix): >> >>create unique index tablename_pi on tablename (fieldnames); >>alter table tablename add constraint primary key (fieldnames) >> constraint tablename_pk;>> >>When you create the unique index for the primary key and the primary >>key itself this way you can give it a proper name that Access will >>understand. >>Additionally you gain the benefit of beeing able to manipulate the >>index independently of the primary key for such purposes as recreating >>it if it ever gets corrupted, detatching it or whatever. >> > >We're still having trouble. I don't work on the Informix database, others do. >I work on an Access based user interface to the data. I showed them a copy >of your posting and they said that they create the indexes exactly as you >specified. But, when you attach the table to the Access database, Access asks >you to specify the unique key. If you don't specify which field is the unique >key then Access treats the table as read-only. If you do specify a field, the >table is updatable. > >As others have said, the interface seems pretty slow, plus we have a lot of >tables to attach and it is error prone. > The Informix support person tells me that you have to enter which of the fields is the unique key in Access when you attach the table. I think he must be mistaken. Howard