RE: Re: Problems with Acess

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