weird Access problem

Hello all,

I connect to a postgresql database from MS Access and I see some weird
things in the postgresql log in C:\psqlodbc_XXX.log. I am using an Access
form to enter data into a table, and the sql log has these insane long
lines with repeated OR terms:

conn=43911292, query='SELECT "SystemID","MailingListID","SystemType"
FROM "Systems" WHERE "SystemID" = 'system5' OR "SystemID" = 'System34' OR
"SystemID" = 'System34' OR "SystemID" = 'System34' OR "SystemID" =
'System34' OR "SystemID" = 'System34' OR "SystemID" = 'System34' OR
"SystemID" = 'System34' OR "SystemID" = 'System34' OR "SystemID" =
'System34''
[ fetched 2 rows ]

Access freezes up (Task not responding, ctrl-alt-del > "End task" works)
if I keep working after this starts happening.

Using Access97 SR-1 on Win95 with iodbc 6.40.0007. The tables in Access
are "linked" to those in pgsql via a system DSN. PostgreSQL is running on
OpenBSD 2.6.

Is this a problem with Access or with the way I'm using the connectivity?
I'm not a guru; I'm just trying to set up a simple demo and I'd rather it
didn't crash while I'm running it.

Thanks
--Louis <louis(at)bertrandtech(dot)on(dot)ca>

Louis Bertrand http://www.bertrandtech.on.ca/
Bertrand Technical Services, Bowmanville, ON, Canada

OpenBSD: Secure by default. http://www.openbsd.org/