============================================================================
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
fieldis 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
openthe 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:
---------
--------------------------------------------------------------------------