Hello !
I've the same problem, I can't link PostgreSQL 8.1.0 tables in an
Access 2000 database using psqlODBC 8.01.0100
I uninstall this driver and I install psqlODBC 8.00.102
now all is working !
I test on a Windows XP Pro box with Access 2000 and psqlODBC 8.01.0100
without any problem !?
This problem seems specific to Windows 2000 Pro...
----- Original Message -----
From: "Andreas" <maps.on@gmx.net>
To: <pgsql-odbc@postgresql.org>
Sent: Wednesday, November 09, 2005 10:08 PM
Subject: [ODBC] Invisible tables in Access 2000
> Hi,
>
> I've got a windows 2000 box where I installed PG 8.1 today.
> Actually I installed pgsqlODBC 8.1.1 before and PG 8.1 on a OpenSuSE
> 10.0 notebook but later I droped pgsqlODBC 8.1.1 on my desktop and
> installed PG 8.1 here too, because I thought the ODBC that comes with it
> would work more harmonic.
>
> Now I can't see my own tables when I try to link them manually via
> dialog into Access 2000 wheras the PG system tables are visible and I
> can link them.
> Linking my own tables by VBA code works though.
>
> StarOffice 8.0 on the contrary can only "see" my tables.
> So it shouldn't be a DSN problem.
>
> This issue emerged when I swiched from PG 8.0.x or it's generation of
> ODBC drivers to the newer versions.
>
> Any idea what could cause this ?
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>