RE: [INTERFACES] MSAccess and primary keys - Mailing list pgsql-interfaces

From Michael J Davis
Subject RE: [INTERFACES] MSAccess and primary keys
Date
Msg-id 93C04F1F5173D211A27900105AA8FCFC1454FD@lambic.prevuenet.com
Whole thread Raw
In response to [INTERFACES] MSAccess and primary keys  (leif@danmos.dk)
List pgsql-interfaces
Make sure the "Recognize Unique Indexes" flag is turned on in the PostgreSQL
ODBC driver.
-----Original Message-----From:    leif@danmos.dk [SMTP:leif@danmos.dk]Sent:    Saturday, May 15, 1999 2:35 AMTo:
pgsql-interfaces@postgreSQL.orgSubject:   [INTERFACES] MSAccess and primary keys
 

 [Sorry for reposting this, the subject got garbled.]

   Hello,
  I have a rather anoying problem. I am linking a quite largeM$Access application to a PostgreSQL database with a a lot
ofrelations(primary keys/foreign keys). In all my tables I havecreated primary keys (to keep M$Access happy ;-).
Unfortunately,whenI link my application to the database, Access asks me foreach and every table (there are more than 80
ofthem) what Iwant to use for unique index field. I thought the primary keyspec would do just that?
 
  All tables are designed like the one below:

create table globalafvigelse   (    id serial ,    startdato date,    slutdato date,    dagskema varchar(50),
primarykey (globalafvigelse)   );
 

    Greetings,
  Leif  (leif@danmos.dk)


pgsql-interfaces by date:

Previous
From: "Geoffrey C. Speicher"
Date:
Subject: Re: [INTERFACES] MSAccess and primary keys
Next
From: Keith/Suzanne Barron
Date:
Subject: Problem loading jdbc driver in servlet, but not in program