'Set lock mode' from MS Access to Informix on Unix

Hi I am running a query in MS Access which is trying to reach a table that is on an AIX-Unix.The server is Informix 7.20. Another process is running on Unix at the same time and writing to this table.So I am getting an error:'ODBC call failed' and then the error:'-107 ISAM error: record is locked'. The solution to this problem in Unix is the command: 'set lock mode to wait'. The problem with MS Access is that even if I succeed to open a session (OpenDatabase) and do 'set lock mode', the query that I am running with DoCmd.OpenQuery (I can't run it only from code it should be flexible) right after, is sometimes running in different session. So the 'set lock mode' have no influence on the session of the query. Sometimes it runs in the same session but I want a 100% solution. Please help if you have ever seen this problem. Thanks Yael Kline Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.