<None>

net!news.sprintlink.net!news-dc-2.sprintlink.net!news1.dis.wa.gov!news.leg.wa.gov!not-for-mail From: Rick Schnabel <Schnabel_ri@leg.wa.gov> Subject: Re: ODBC Driver Message-ID: <31EBD390.7E46@leg.wa.gov> Date: Tue, 16 Jul 1996 10:38:24 -0700 Organization: Washington State Senate X-Mailer: Mozilla 2.0 (WinNT; I) MIME-Version: 1.0 References: <31EBCA43.1B56@fonorola.com> <4sg8tf$i4l@zebedee.ingres.co.uk> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 14 > >My problem comes when I try to update a field on the database. When I try to do > >that, the database gives me the error: "The field is not updatable". I cannot > >enter new data or change the existing records ( and to me, not being able > >to update the records or enter new records defeats the purpose of having an > >ODBC driver) > > How about adding a unique secondary index on your tables. The Jet engine > (under MSAccess) requires unique indexes (or in some cases, a unique primary > key). You may have a primary key in Infomix, but Access won't use it. This is because if you created the primary key before you created a unique index the database will create the index for you, but it puts a space at the start of the name of the index. Access won't use an index with a space at the start of the name of the index.