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

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???
>>
>