Unanswered: Does ODBC connection from INFORMIX DB to MS ACCESS has committed read on the data?
Question: Hello Experts,
I have created an ODBC Connection between Informix Database and MS Access, and I am accessing those tables data using MS Access. Does this lock the tables, and if there are any updates to be made on those table, will those update jobs fail while I am using the data.
I have got few colleagues who say that, MS Access has a commited Read, and I need to set the flag to no, so that if there were any underlying process updates on these tables, the process would not break.
Can you please let me know if this really happens. I was under the assumption that If I am making an ODBC connection, then I am only reading it as an interface and all the other processes would scuccessfully run.