Re: BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQL

No. You probably need someone more knowledgeable than myself! Now that
you have narrowed down the problem, someone should be able to help.

You will need to provide more details about your system. i.e. operating
system, PostgreSQL server version, driver version (I assume ODBC), and
MS Access version...

Matt

Annita Veneti wrote:
> Matt you are absolutely right! The msysconf is not related...
> Yesterday I did some test and have seen that the access is working fine with postgres as long as the SSL mode is disable, as soon as I put it enabled then it crashes on shutdown....
>
> Go figure!!!
>
> Any ideas?
>
> Annita
>
> -----Ursprüngliche Nachricht-----
> Von: Matt Taylor [mailto:matt(at)lindenelevator(dot)com]
> Gesendet: Montag, 21. September 2009 23:07
> An: Annita Veneti
> Cc: pgsql-bugs(at)postgresql(dot)org
> Betreff: Re: [BUGS] BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQL
>
> I think the msysconf error is not related to your issue:
>
> http://archives.postgresql.org/pgadmin-support/2002-01/msg00035.php
>
> Can you query data from the data source using MS Excel?
>
> Matt
>
>
> Annita Veneti wrote:
>> Matt first thanks for the reply,
>>
>> I have check the log and it says
>>
>> Relation »msysconf« existiert nicht (that it doesn’t exist.
>>
>> I know that there is a setting in the pgAdmin to postgre create the table if it not there.
>> But I cannot find it , do you have any idea?
>>
>>
>> Annita
>>
>>
>> -----Ursprüngliche Nachricht-----
>> Von: Matt Taylor [mailto:matt(at)lindenelevator(dot)com]
>> Gesendet: Freitag, 18. September 2009 17:47
>> An: Annita Veneti
>> Cc: pgsql-bugs(at)postgresql(dot)org
>> Betreff: Re: [BUGS] BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQL
>>
>> Have you tried turning on row versioning in the data source?
>>
>> Matt
>>
>>
>> Annita wrote:
>>> The following bug has been logged online:
>>>
>>> Bug reference: 5063
>>> Logged by: Annita
>>> Email address: annita(dot)veneti(at)qs-unisolution(dot)com
>>> PostgreSQL version: 8
>>> Operating system: Windows
>>> Description: MS Access crashes by quiting after linking tables with
>>> PostgreSQL
>>> Details:
>>>
>>> MS Access (2003,2007) crashes by closing down , after i have linked the
>>> tables of my postgreSQL database. I cannot find anything relevant with this
>>> problem. I have tried everything, the problem has to do with the
>>> postgredriver since this doesnt happen when i connect with MySql or SQL.
>>>
>>> CAN ANYONE HELP??? please???
>>>
>