Re: Re: Problems with Acess

From: Schollum(at)t-online(dot)de (Norbert Schollum)
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Re: Problems with Acess
Date: 2001-03-16 21:57:28
Message-ID: 3AB28C48.38097DD8@t-online.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

i cant find any hint in this file.
the transaction is stopped by Rollback.

it would be interesting, what Postgres is telling Access ....

i have attached the logfile.

Michael Davis wrote:
>
> Turn on logging in the PostgreSQL ODBC driver, retry the update, and look
> at c:\psqlodbc###.log. This log file has been very helpful at helping see
> what Access is telling PostgreSQL to do.
>
> -----Original Message-----
> From: Norbert Schollum [SMTP:Schollum(at)t-online(dot)de]
> Sent: Friday, March 16, 2001 2:32 PM
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] Re: Problems with Acess
>
> i cant update the record even if i quit access and restart it.
> what else could be wrong?
>
> Fabio Nanni wrote:
> >
> > Hi,
> > I experienced the same type of problem in the past, but not now. I
> > cannot say why, too many things are changed in the meantime
> > (PostgreSQL7.1B4, W$2K, Access2K, odbc 7.X), but perhaps you can try to
> > refresh the record you just modified before trying a second update (or
> > modify the refresh interval of the linked tables, in
> > Tools->Options->Advanced->ODBC refresh interval).
> >
> > hope this helps...
> > Fabio
> >
> > Norbert Schollum wrote:
> > >
> > > Hello,
> > >
> > > ...
> > > but there are some entries, which i can only edit one time.
> > > the next time i try to update them, i get the message,
> > > that another user is working on this entry - but there is
> > > no other user doing this!
>
> --
> Comtec Computersysteme
> Norbert Schollum -=-_-- ICQ 4261631
> Lindenweg 9 Fon+Fax (0700) 333 888 00
> 84576 Teising http://www.comtec-computer.de
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
Comtec Computersysteme
Norbert Schollum -=-_-- ICQ 4261631
Lindenweg 9 Fon+Fax (0700) 333 888 00
84576 Teising http://www.comtec-computer.de

Attachment Content-Type Size
psqlodbc_168.log application/x-unknown-content-type-txtfile 17.0 KB

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Michael Moehle 2001-03-16 22:21:35 AW: Re: Problems with Acess
Previous Message Tom Lane 2001-03-16 21:37:45 Re: Re: Problems with Acess