Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] ODBC and Access 2000: linked tables problem

From: Byron Nikolaidis <byronn(at)solipsys(dot)com>
To: Moray McConnachie <Moray(dot)McConnachie(at)computing-services(dot)oxford(dot)ac(dot)uk>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] ODBC and Access 2000: linked tables problem
Date: 1999-06-29 13:35:29
Message-ID: 3778CBA1.CF52B12A@solipsys.com (view raw or flat)
Thread:
Lists: pgsql-interfaces

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



In response to

Responses

pgsql-interfaces by date

Next:From: Byron NikolaidisDate: 1999-06-29 14:02:12
Subject: Re: [INTERFACES] ODBC: OID column in views
Previous:From: Pablo Saul Salazar - CESERCOMPDate: 1999-06-29 13:08:37
Subject: Problem with Libpq

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group