From: Hannu Krosing <hannu@trust.ee>
To: Ewan Mellor <em@nexus.co.uk>
Cc: PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name'
Date: Tue, 12 May 1998 17:53:05 +0300
Message-ID: <35586251.D6B32970@trust.ee> (raw)
References: <35582955.5F014F7B@nexus.co.uk>
Ewan Mellor wrote:
>
> 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.
Starting from v2.0 of Access the worn "name" became kind of reserved
word in Access, as the table itself aquired an _attribute_ name, which
contains the name of the table.
so having a field called name is a problem in anyway (for Access).
I have no idea why "sortname" or "garbagename" does not work.
> 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.
you can still do
ALTER TABLE yourtable RENAME name TO not_name_any_more;
-------------
Hannu
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: hannu@trust.ee, em@nexus.co.uk
Subject: Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name'
In-Reply-To: <35586251.D6B32970@trust.ee>
* 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