Re: ODBC/MSAccess

Rick Schnabel wrote: > > 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. Well Rickbo, you have the aswer, as always. John Gose -- John Gose Gose_Jo@leg.wa.gov Opinions expressed in this message do not necessarily reflect those of myself, my organization or anybody else. I don't know where they come from... it scares me sometimes.