MS Access & PsqlODBC: Invalid field name 'name'
Ewan Mellor <em@nexus.co.uk>
From: Ewan Mellor <em@nexus.co.uk>
To: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Date: 1998-05-12T10:49:57Z
Lists: pgsql-hackers
I am using Byron's ODBC driver (version .0239 downloaded today) with Access 7.00 under Win95 with Postgres 6.3. I am trying to link tables into Access. Most tables work fine, but any field with the name 'name' or 'sortname' or even 'garbagename' may not be used as part of an index. This occurs whether the index is picked up automatically by the driver, or if you are asked to choose a unique field by Access. Can this be fixed? As a workaround, could the driver optionally not tell the client application about indices? In this way, I could tell Access to ignore them and then (I think) I would be able to get at my data. Ewan Mellor.