Re: ODBC/MSAccess

Jack Parker wrote: > > Folks, > > I haven't been following the many threads on ODBC. The question came up > hte other dat and I didn't have an answer. Could someone recap the current > state of affairs with the MSAccess/ODBC situation? For that matter > are these things stable enough to write up a new chapter for the FAQ? > > cheers > j. > _____________________________________________________________________________ > Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA > jparker@hpbs3645.boi.hp.com Back in Boise > _____________________________________________________________________________ > > If anything can go wrong, fix it. To hell with Murphy. > _____________________________________________________________________________ > Any opinions expressed herein are my own and not those of my employers. > _____________________________________________________________________________ The basic problem is that Informix will create the Primary Key Names and the supporting index names for you. If either you do not provide them or you create them in the "Wrong?" order. When the database creates them for you the names start with a space. Access does not like that. The way around that is create the indexes first with out a primary key then go back and alter the table and add the primary key. Be sure to specify the index and key names with out the space up front. If you do that Access is happy.