Re: MS Access / Informix connection is read-only

On 2 Apr 98 00:06:31 GMT, hwittenb@pacbell.net (Howard Wittenberg) wrote: >Thanks for the thought(s). I believe we have the problem solved. It was with >the keys... Apparently the owner of the keys wasn't the same as the tables and >the drivers wouldn't recognize the keys. Anyway, they say they are fixing the >problem and we should be able to reattach the tables and they will be OK. This >wasn't a problem with the 16-bit Visigenic drivers. > >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. >Howard Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: Primary with ODBC info: http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html