MS Access problems

From: Fabio Nanni <f(dot)nanni(at)albourne(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: MS Access problems
Date: 2000-08-18 21:27:16
Message-ID: 399DAA34.A4870D95@albourne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hello all,

I have two problems in accessing a psql database via MS-Access-ODBC, and
I cannot find anything similar on the mailing list. I am a novice to
psql and ODBC, has anybody perhaps faced these problems?

The configuration was:
Client side:
- MS Access 97 SR-2 running on NT 4.0 (Build 1381: Service Pack 6)
- odbc driver version: 6.50.0000
Server side:
- postgresql database, version: 7.0.0

The problems are:
1. when linking a table, Access is unable to find automatically the
primary key and raises a dialog asking me to specify it.
I attached the tracelog file due to the linking of the table below:
Table "currencies"
Attribute | Type | Modifier
------------+---------+----------------------
curr | char(3) | not null
curr_name | text | not null
curr_quote | boolean | not null default '1'
Index: currencies_pkey

2. Access is unable to discover automatically
relations and foreign keys in the database.

Many thanks in advance
Fabio

Attachment Content-Type Size
psqlodbc.log.gz application/x-gzip 2.3 KB

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tim Uckun 2000-08-18 21:42:17 Re: MS Access + Postgres
Previous Message Jim O'Rourke 2000-08-18 14:58:51 /tmp/.s.PGSQL.${PGPORT}