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@t-online.de]
Sent: Friday, March 16, 2001 2:32 PM
To: pgsql-odbc@postgresql.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