Re: MS ACCESS <-> DSA

May be you remember the following post that was my response to "VB Read only problem with Informix.. HELP!!!!" on 97.01.15: It may be the indexing problem seen in MS Access. If you use DAO in VB that is likely. If you use RDO as you should for speed reasons (significantly faster database access) it is less likely. In any case, if this is the problem you fix it like this: First you need a primary key. Second you should declare it as follows: create tabel tabelname( somecolumn sometype, { The primary key } .... ); create unique index tabelname_primary on tabelname (somecolumn); alter table tabelname add constraint primary key (somecolumn) constraint tabelname_primkey; to avoid any problems with Informix generated constraint names starting with a space. This way of defining a primary key also have the advantage of making it possible to drop and recreate the index independently of the primary key constraint. jlumbley@netcom.com (Joe Lumbley) wrote: : :How about a quick pointer to something I remember seeing here? :altavista and iiug searches don't find this. : :Someone wrote about & solved a problem about connecting MSACCESS to 7.xx. :Problem was a problem with inserts/updates (I believe). The answer had :to do with the need to have a unique index on the tables. At the time :I saw it I wasn't interested in Access...now one of my cohorts has a :similar problem and I'd appreciate a pointer to the original article thread. :TIA. : :Joe :-- :--------------------------------------------------------------------------- :Joe Lumbley(jlumbley@netcom.com) :--------------------------------------------------------------------------- Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org