Access ODBC worries - Mailing list pgsql-interfaces

Hi All
I have been battling with a problem now for days.  
I have a linked form in Access 97 to linked tables to a PGSQL backend
via ODBC.
The code works well, but after the form has been on the screen for 
about 20 minutes idling or doing something (makes no difference) then
all hell breaks loose.  The computer tries to requery the form data
from the backend in a very strange way.  The odbc log file output at the
bottom of this message explains the problem in greater detail.
If anyone can tell me:
1) How to prevent the requerying from occuring and/or
2) How to ensure the correct query is being executed,
it would be very helpful
Ciao
Mark
A brief note re the output that follows.  The first queries shown are correct.  
They correctly fetch the required info and are supposed to happen.  The
form potters along for a while doing stuff and then hits a wall in the 
problem arising towards the bottom where the master form requeries its data
(check out the SQL statement ... or oid= ... or oid=  ... or oid= ...!)
and unsurprisingly bombs out, causing the second (subform) requery to also 
bomb out by executing a null query.
LOG output:
===========
DSN info:
DSN='PostgreSQLaccess',server='pgsql',port='5432',dbase='timerecordal',user='mark',passwd='1234'
readonly='0',protocol='6.4',showoid='1',fakeoidindex='1',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0006', fetch=100, socket=4096, unknown_sizes=0,
max_varchar_size=254, max_longvarchar_size=4094
disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=91718104, query=' '
conn=91718104, query='set DateStyle to 'ISO''
conn=91718104, query='set geqo to 'OFF''
conn=91718104, query='set ksqo to 'ON''
conn=91718104, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=91718104,

SQLDriverConnect(out)='DSN=PostgreSQLaccess;DATABASE=timerecordal;SERVER=pgsql;PORT=5432;UID=mark;PWD=1234;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=1;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
conn=91718104, query='SELECT "Toplevel time recordal"."oid" FROM "Toplevel time
recordal" WHERE ("File link" =  383970 ) ORDER BY "Startdate"  DESC '
[ fetched 1 rows ]
conn=91718104, SQLDisconnect
conn=91637836, query='SELECT "oid","ID","File link","Billing
code","Startdate","Sumtime","fulltimestore","username2","username"  FROM "Toplevel
time recordal"  WHERE "oid" = 140608'
[ fetched 1 rows ]
conn=91637836, query='SELECT "oid","Client code","Client details"  FROM "Client
details"  WHERE "oid" = 69716'
[ fetched 1 rows ]
conn=91637836, query='SELECT "oid","Case number","Case name","ClientID"  FROM "File
details"  WHERE "oid" = 125742'
[ fetched 1 rows ]
conn=91555964, query='SELECT "Billing description"  FROM "Billing codes" WHERE
("Billing code" = 1 ) '
[ fetched 1 rows ]
conn=91637836, query='SELECT "oid","ID","File link","Billing
code","Startdate","Sumtime","fulltimestore","username2","username"  FROM "Toplevel
time recordal"  WHERE "oid" = 140608'
[ fetched 1 rows ]
conn=91637836, query='BEGIN'
conn=91637836, query='UPDATE "Toplevel time recordal" SET
"Sumtime"=2123,"fulltimestore"='0:35:23'  WHERE "oid" = 140608 AND "ID" IS NULL AND
"File link" = 383970 AND "Billing code" = 1 AND "Startdate" = '1999-08-12' AND
"Sumtime" = 1822 AND "username" = 'womxw     ''
conn=91637836, query='COMMIT'
conn=91637836, query='SELECT "oid","ID","File link","Billing
code","Startdate","Sumtime","fulltimestore","username2","username"  FROM "Toplevel
time recordal" WHERE ("File link" =  383970 ) ORDER BY "Startdate"  DESC '
[ fetched 1 rows ]
conn=91637836, query='SELECT "oid","ID","File link","Billing
code","Startdate","Sumtime","fulltimestore","username2","username"  FROM "Toplevel
time recordal"  WHERE "oid" = 140608'
[ fetched 1 rows ]
conn=91555964, SQLDisconnect
conn=91637836, query='BEGIN'
conn=91637836, query='UPDATE "Toplevel time recordal" SET
"Sumtime"=2424,"fulltimestore"='0:40:24'  WHERE "oid" = 140608 AND "ID" IS NULL AND
"File link" = 383970 AND "Billing code" = 1 AND "Startdate" = '1999-08-12' AND
"Sumtime" = 2123 AND "username" = 'womxw     ''
conn=91637836, query='COMMIT'
conn=91637836, query='SELECT "oid","ID","File link","Billing
code","Startdate","Sumtime","fulltimestore","username2","username"  FROM "Toplevel
time recordal" WHERE ("File link" =  383970 ) ORDER BY "Startdate"  DESC '
[ fetched 1 rows ]
conn=91637836, query='SELECT "oid","ID","File link","Billing
code","Startdate","Sumtime","fulltimestore","username2","username"  FROM "Toplevel
time recordal"  WHERE "oid" = 140608'
[ fetched 1 rows ]
conn=91637836, query='BEGIN'
conn=91637836, query='UPDATE "Toplevel time recordal" SET
"Sumtime"=2725,"fulltimestore"='0:45:25'  WHERE "oid" = 140608 AND "ID" IS NULL AND
"File link" = 383970 AND "Billing code" = 1 AND "Startdate" = '1999-08-12' AND
"Sumtime" = 2424 AND "username" = 'womxw     ''
conn=91637836, query='COMMIT'
conn=91637836, query='SELECT "oid","ID","File link","Billing
code","Startdate","Sumtime","fulltimestore","username2","username"  FROM "Toplevel
time recordal" WHERE ("File link" =  383970 ) ORDER BY "Startdate"  DESC '
[ fetched 1 rows ]
conn=91637836, query='SELECT "oid","ID","File link","Billing
code","Startdate","Sumtime","fulltimestore","username2","username"  FROM "Toplevel
time recordal"  WHERE "oid" = 140608'
[ fetched 1 rows ]
conn=91637836, query='BEGIN'
conn=91637836, query='UPDATE "Toplevel time recordal" SET
"Sumtime"=3026,"fulltimestore"='0:50:26'  WHERE "oid" = 140608 AND "ID" IS NULL AND
"File link" = 383970 AND "Billing code" = 1 AND "Startdate" = '1999-08-12' AND
"Sumtime" = 2725 AND "username" = 'womxw     ''
conn=91637836, query='COMMIT'
conn=91637836, query='SELECT "oid","ID","File link","Billing
code","Startdate","Sumtime","fulltimestore","username2","username"  FROM "Toplevel
time recordal" WHERE ("File link" =  383970 ) ORDER BY "Startdate"  DESC '
[ fetched 1 rows ]
conn=91637836, query='SELECT "oid","ID","File link","Billing
code","Startdate","Sumtime","fulltimestore","username2","username"  FROM "Toplevel
time recordal"  WHERE "oid" = 140608'
[ fetched 1 rows ]
conn=91637836, query='SELECT "oid","Client '#S_C_H#',"Client details"  FROM "Client
details"  WHERE "oid" = 69716 OR "oid" = 69716 OR "oid" = 69716 OR "oid" = 69716 OR
"oid" = 69716 OR "oid" = 69716 OR "oid" = 69716 OR "oid" = 69716 OR "oid" = 69716 OR
"oid" = 69716'
ERROR from backend during send_query: 'ERROR:  parser: parse error at or near
"client"'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the
query'
------------------------------------------------------------
hdbc=91637836, stmt=92046804, result=0
manual_result=0, prepare=1, internal=0
bindings=0, bindings_allocated=0
parameters=91637300, parameters_allocated=10
statement_type=0, statement='SELECT "oid","Client '#S_C_H#',"Client details"  FROM
"Client details"  WHERE "oid" = ? OR "oid" = ? OR "oid" = ? OR "oid" = ? OR "oid" = ?
OR "oid" = ? OR "oid" = ? OR "oid" = ? OR "oid" = ? OR "oid" = ?'
stmt_with_params='SELECT "oid","Client '#S_C_H#',"Client details"  FROM "Client
details"  WHERE "oid" = 69716 OR "oid" = 69716 OR "oid" = 69716 OR "oid" = 69716 OR
"oid" = 69716 OR "oid" = 69716 OR "oid" = 69716 OR "oid" = 69716 OR "oid" = 69716 OR
"oid" = 69716'
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
cursor_name='SQL_CUR057C85D4'
----------------QResult Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR:  parser: parse error
at or near "client"'
------------------------------------------------------------
henv=92602516, conn=91637836, status=1, num_stmts=16
sock=92605152, stmts=92605192, lobj_type=-999
---------------- Socket Info -------------------------------
socket=208, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=91644164, buffer_out=91648264
buffer_filled_in=50, buffer_filled_out=0, buffer_read_in=50
conn=91637836, query='SELECT "oid","Client code","Client details"  FROM "Client
details"  WHERE "oid" = 69716 OR "oid" = 69716 OR "oid" = 69716 OR "oid" = 69716 OR
"oid" = 69716 OR "oid" = 69716 OR "oid" = 69716 OR "oid" = 69716 OR "oid" = 69716 OR
"oid" = 69716'
[ fetched 1 rows ]
conn=91637836, query='SELECT "oid","Case number","Case name","ClientID"  FROM "File
details"  WHERE "oid" = 125742 OR "oid" = 125742 OR "oid" = 125742 OR "oid" = 125742
OR "oid" = 125742 OR "oid" = 125742 OR "oid" = 125742 OR "oid" = 125742 OR "oid" =
125742 OR "oid" = 125742'
[ fetched 1 rows ]
conn=91652364, SQLDriverConnect(

in)='DSN=PostgreSQLaccess;UID=mark;PWD=1234;DATABASE=timerecordal;SERVER=pgsql;PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=1;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;',
fDriverCompletion=0
DSN info:
DSN='PostgreSQLaccess',server='pgsql',port='5432',dbase='timerecordal',user='mark',passwd='1234'
readonly='0',protocol='6.4',showoid='1',fakeoidindex='1',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0006', fetch=100, socket=4096, unknown_sizes=0,
max_varchar_size=254, max_longvarchar_size=4094
disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=91652364, query=' '
conn=91652364, query='set DateStyle to 'ISO''
conn=91652364, query='set geqo to 'OFF''
conn=91652364, query='set ksqo to 'ON''
conn=91652364, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=91652364,

SQLDriverConnect(out)='DSN=PostgreSQLaccess;DATABASE=timerecordal;SERVER=pgsql;PORT=5432;UID=mark;PWD=1234;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=1;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
conn=91652364, query='SELECT "Toplevel time recordal"."oid" FROM "Toplevel time
recordal" WHERE ("File link" =  NULL ) ORDER BY "Startdate"  DESC '
ERROR from backend during send_query: 'ERROR:  parser: parse error at or near "null"'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the
query'
------------------------------------------------------------
hdbc=91652364, stmt=91555964, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=92605260, parameters_allocated=1
statement_type=0, statement='SELECT "Toplevel time recordal"."oid" FROM "Toplevel time
recordal" WHERE ("File link" =  ? ) ORDER BY "Startdate"  DESC '
stmt_with_params='SELECT "Toplevel time recordal"."oid" FROM "Toplevel time recordal"
WHERE ("File link" =  NULL ) ORDER BY "Startdate"  DESC '
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
cursor_name='SQL_CUR0575087C'
----------------QResult Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR:  parser: parse error
at or near "null"'
------------------------------------------------------------
henv=92602516, conn=91652364, status=1, num_stmts=16
sock=92602708, stmts=92602532, lobj_type=-999
---------------- Socket Info -------------------------------
socket=204, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=91658692, buffer_out=91662792
buffer_filled_in=48, buffer_filled_out=0, buffer_read_in=48
conn=91637836, SQLDisconnect
conn=91652364, SQLDisconnect