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