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