From: leif@danmos.dk
To: pgsql-interfaces@postgreSQL.org
Subject: [INTERFACES] MSAccess and primary keys
Date: Sat, 15 May 1999 10:34:45 +0200
Message-ID: <199905150834.KAA28939@crysberg.dk> (raw)
[Sorry for reposting this, the subject got garbled.]
Hello,
I have a rather anoying problem. I am linking a quite large
M$Access application to a PostgreSQL database with a a lot of
relations (primary keys/foreign keys). In all my tables I have
created primary keys (to keep M$Access happy ;-). Unfortunately,
when I link my application to the database, Access asks me for
each and every table (there are more than 80 of them) what I
want to use for unique index field. I thought the primary key
spec would do just that?
All tables are designed like the one below:
create table globalafvigelse
(
id serial ,
startdato date,
slutdato date,
dagskema varchar(50),
primary key (globalafvigelse)
);
Greetings,
Leif
(leif@danmos.dk)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: leif@danmos.dk
Subject: Re: [INTERFACES] MSAccess and primary keys
In-Reply-To: <199905150834.KAA28939@crysberg.dk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox