Re: MS Access & Informix Workgroup edition

The first thing to check is to make sure that you're tables are set to Row-Level locks, instead of Page-Level. While this doesn't answer the general question, which is valid. Most of the time, I find that this will make the problem go away. SQL to check & set : -- locklevel P=Page, R=Row select tabname,locklevel from systables where tabid = "dbins" ; alter table dbins lock mode (row); nonbeliever wrote: > We may be a little behind the times, so bear with me on this one :) > > We just upgraded from "Standard" engine to "Workgroup" Informix engine. > Since doing that we are getting record locks - OK no problem with dbaccess - > just use 'set isolation dirty read'. Big problem with Microsoft Access > using the Merant ODBC drivers. We can not find a way to make MS Access > utilize the dirty read. Instead all we get are ODBC errors indicating > record locks. > > Can anyone let me know how to set MS Access to dirty read? > > Thank you all in advance - this is my first time posting, but have read this > board for a couple of weeks and learned many new (to me anyway) things! > Keep up the good work! -- ============================================================== Mark Steen Principal Systems Engineer Informix Software, Inc. 8310 N. Capital of Texas Hwy. Suite 285 Austin, TX 78731 Phone : (512) 342-1022 x-206 FAX : (512) 231-0940 mailto: mark.steen@informix.com ============================================================== There are two major products that come out of Berkeley: LSD and UNIX. We don't believe this to be a coincidence. - Jeremy S. Anderson