by net!news.sprintlink.net!news-dc-2.sprintlink.net!news1.dis.wa.gov!news.leg. > How about adding a unique secondary index on your tables. The Jet engine
Subject: Re: ODBC Driver
Date: Tue, 16 Jul 1996 10:38:24 -0700
Organization: Washington State Senate
X-Mailer: Mozilla 2.0 (WinNT; I)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 14
You may have a primary key in Infomix, but Access won't use it. This is because
> >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)
> (under MSAccess) requires unique indexes (or in some cases, a unique primary
> key).
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.
