Обсуждение: 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

Mr. Nanni,

> 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.

This is an MS Access problem.  Access is rarely able to
automatically discern primary or foriegn keys in ODBC
databases.  I have the same problem with attaching MS SQL
Server tables, which are supposedly 100% compatible.

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

See Above.

You're going to have to settle for specifying the primary
key on creation of the linked table, and re-creating the
foriegn keys on the client side, or simply coding in the
referential integrity.

-Josh Berkus