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

Re: Invisible tables in Access 2000

From: Secrétariat <ets(at)rolland-fr(dot)com>
To: "Andreas" <maps(dot)on(at)gmx(dot)net>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Invisible tables in Access 2000
Date: 2005-11-09 21:32:10
Message-ID: 007c01c5e575$0c1e64e0$6a00a8c0@scenict845g (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
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

In response to


pgsql-odbc by date

Next:From: AndreasDate: 2005-11-09 23:57:36
Subject: Re: How remove stale DSN ?
Previous:From: George WeaverDate: 2005-11-09 21:30:37
Subject: Re: How remove stale DSN ?

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