Re: Invisible tables in Access 2000

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(dot)on(at)gmx(dot)net>
To: <pgsql-odbc(at)postgresql(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>