General Bug Report: ODBC Broken with Office 2000

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               : Korey Bliss
Your email address      : kjb0566@rit.edu

Category                : runtime: back-end: SQL
Severity                : serious

Summary: ODBC Broken with Office 2000

System Configuration
--------------------
  Operating System   : RedHat Linux 2.0.35

  PostgreSQL version : 6.3

  Compiler used      : Pre-compiled

Hardware:
---------
Pentium Pro 200 w/ MMX, 48 MB RAM
Linux atvparts.com 2.0.35 #1 Tue Jul 14 23:56:39 EDT 1998 i686 unknown

Versions of other tools:
------------------------


--------------------------------------------------------------------------

Problem Description:
--------------------
When linking databases, Access 2000 is unable to to read a table that has a unique index field.  Since having this field is the only way Access can write to a linked table, they can be read from.

--------------------------------------------------------------------------

Test Case:
----------
-Install the latest Postdrv.exe driver to the client system.
-Install Office 2000 (the biggest pain)
-Make a new database in Access and link a table.  Choose ODBC as the type and select a PostgreSQL server.
-After you select the table, Access will ask if you want to select a unique record identifier.  Pick one, then try to open the table.  Note the strange error message.
-Delete the table and relink it, this time don't select a unique record identifier.  Open the table (it should come up fine, read-only however).

--------------------------------------------------------------------------

Solution:
---------


--------------------------------------------------------------------------