Re: Access through seqlink to Informix, table name problems

Kate Tomchik/IS/SSC/THD@emory.mathcs.emory.edu wrote: :I don't use Access or Seqlink very often, so I need help with this problem. We :are :using Access Version 2.0 talking to Infomrix version 5.03. Two of the table :names :on Informix seem to be too long for the Access environment to allow them to be :updated from Access. Is this a reality? Or do we have a parameter set :incorrectly? :The Access server cannot successfully find the object with just the table name :(act_is_proj_empl). If we make a view of the table with a shorter name, we can :"Sucessfully Attached" the table, but we still can't update the table. I don't know about the long names. The common reason for not beeing able to update a table via MS Access is that there is no unique index on the table or that the name of that unique index is system generated and contains a space as the first character. For some reason MS Access can't deal with that. For this and other reasons we allways create a primary key this way: create unique index tablename_primary on tablename (columnname); alter table tablename add constraint primary key (columnname) constraint tablename_primkey; Of course if you have table names longer than 10 characters you will have to change the _primary and _primkey part of the index and primary key constraint names above. 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