General Bug Report: ODBC Broken with Office 2000

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

Your name : Korey Bliss
Your email address : kjb0566(at)rit(dot)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:
---------

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