From: | "w fm3" <wfm3(at)hotmail(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | access 2000 - cannot carry out action at present time, error 2486 |
Date: | 2003-07-14 13:23:48 |
Message-ID: | BAY1-F158262iQQcHua000086c0@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
access 2000 connecting to postgresql db
ODBC driver 7.03.01
Postgresql 7.3.2
--
error message 2486 cannot carry out action at present time
Leaving an open form without activity / Connection idle for approx 2 hours
seems to result in this error
ODBC refresh adjusted from the default 1500 seconds to 60 seconds (Tools
->Options->Advanced) and this no longer seems to be a problem.
No idea on why this occurs though if anybody can shed any light it might be
useful
--
Boolean values work fine for me as long as you stay clear from null values
as an option.
If there is a null value in a boolean field I get the error: Write
Conflict - This record has been changed by another user since you started
editing it.
I think this has been documented elsewhere though.
--
I just thought i would post what worked for me incase anyone has a similar
problem.
Cheers
_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
From | Date | Subject | |
---|---|---|---|
Next Message | Marco Gaiarin | 2003-07-14 13:52:36 | Re: This thing drive me crazy! ;( |
Previous Message | Michael Higgins | 2003-07-11 17:27:57 | odbc error using MS Visio |