MS Access problems

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