Skip site navigation (1) Skip section navigation (2)

Re: [HELP] MSAccess picks wrong keys

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: Aaron Spike <sauron(at)mlc-wels(dot)edu>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: [HELP] MSAccess picks wrong keys
Date: 2004-01-27 15:29:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
--- Aaron Spike <sauron(at)mlc-wels(dot)edu> wrote:
> > So, for you this should "just work".  I don't have
> an
> > answer, but maybe someone else can suggest it.
> Well it didn't just work. Until I dropped and
> recreated the table and 
> copied the data back in. Now it works fine. Its
> almost like the 
> driver knew that the index was on the first field
> and the last two 
> fields.
> Problems and fixes aside can anyone offer more
> information on how the 
> pgodbc driver and access decide whether or not to
> present the "Select 
> Unique Record Identifier" dialogue when linking
> tables?

I suspect that is up to the ODBC driver.  Anybody feel
like hunting through the code for "SQLPrimaryKeys()"?

> > If you don't have logging enabled, you may want to
> try
> > that for a while; there may be some clues in
> there.
> Logging with the odbc driver or on the server?

Driver (MyLog) logging will tell you exactly what the
driver is sending to the server, and what it is doing
with what it gets back.  But that is extremely verbose
and hard to follow.  But may be indispensable if you
are having a problem.

> > BTW, I suggest you reconsider your use of a
> composite
> > primary key.  The fact that they are supported
> doesn't
> > make them a good idea.
> Not my choice actually, but after working with them
> for some time I 
> they have grown on me.
> Aaron Spike

Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!

In response to

pgsql-odbc by date

Next:From: Richard HuxtonDate: 2004-01-27 17:38:16
Subject: Re:
Previous:From: Aaron SpikeDate: 2004-01-26 23:08:46
Subject: Re: [HELP] MSAccess picks wrong keys

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group