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