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
> 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.
In response to
pgsql-interfaces by date
|Next:||From: Byron Nikolaidis||Date: 1999-06-29 14:02:12|
|Subject: Re: [INTERFACES] ODBC: OID column in views|
|Previous:||From: Pablo Saul Salazar - CESERCOMP||Date: 1999-06-29 13:08:37|
|Subject: Problem with Libpq|