From: Byron Nikolaidis <byronn@solipsys.com>
To: Moray McConnachie <Moray.McConnachie@computing-services.oxford.ac.uk>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] ODBC and Access 2000: linked tables problem
Date: Tue, 29 Jun 1999 09:35:29 -0400
Message-ID: <3778CBA1.CF52B12A@solipsys.com> (raw)
References: <EXECMAIL.990629114330.D@moraypc.computing-services.oxford.ac.uk>
Moray McConnachie wrote:
> I was hoping someone could help me out with this, although
> it's probably more of an Access problem than a Postgres
> ODBC one...
>
> I am using Access 2000 and postgres, with the postgres ODBC
> drivers.
>
> Everything worked fine under Access 97.
>
> Importing tables from the ODBC connection is fine.
> *Linking* is fine as far as the table selection and the importing of
> fields and selecting of unique index goes.
>
> However, when I try and open the linked table, it says "Access cannot
> open the table in datasheet view". Nor can it access it via a query. I
> have also tried hardcoding the table in a way which worked in Access 97
> (code appended below), and it fails in exactly the same way.
>
> SQL tracing appears to reveal that when a table is opened,
> Access doesn't even get as far as putting a command to the
> remote database.
>
Send the sql trace log.
Byron
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: byronn@solipsys.com, Moray.McConnachie@computing-services.oxford.ac.uk
Subject: Re: [INTERFACES] ODBC and Access 2000: linked tables problem
In-Reply-To: <3778CBA1.CF52B12A@solipsys.com>
* 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