> Tomas Fulajtar wrote:
> > Hello,
> > I'am using MSAccess 97 with Postgres 7.0x as
> > backend. ODBC driver parameter <Recognize unique
> > indexes> is set to on. When i link table as an ODBC,
> > access manager ask me for unique index for each table.
> > Why don't it recognize my table's primary or foreign keys
> > ? I must set this manualy. I want to link table in VBA
> > code dynamicaly, but for this reason it is impossible
> > (when i do'nt set any field as index, i can't update any
> > table). What solution is for it?
> Which version of psqlodbc driver are you using ?
> Hiroshi Inoue
I solved this problem by upgrading driver to version
7.01.0004. Everything is ok now, each index is
recognized correctly. Only when I link tables without any
unique index i must set index manually to oid.
At end I have a question - what is better for performance
- set recognize unique indexes to on (this require tables
with primary keys ) or set to on fake index. I am using
tables with multi column primary keys.
Thanks for any answer
In response to
pgsql-odbc by date
|Next:||From: Tamsin||Date: 2001-04-06 15:38:22|
|Subject: access #s_c_h#|
|Previous:||From: Hiroshi Inoue||Date: 2001-04-06 06:10:37|
|Subject: Re: MS Access help with boolean values|