From: Ewan Mellor <em@nexus.co.uk>
To: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: MS Access & PsqlODBC: Invalid field name 'name'
Date: Tue, 12 May 1998 11:49:57 +0100
Message-ID: <35582955.5F014F7B@nexus.co.uk> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: em@nexus.co.uk
Subject: Re: MS Access & PsqlODBC: Invalid field name 'name'
In-Reply-To: <35582955.5F014F7B@nexus.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox