ODBC - Need to set it to Read Uncommitted

[june.dalde]

I have a table linked to an Informix database file. When I attempt to read
the file, I get an error: ODBC --call failed. Could not do an indexed read to
get the next row. Record is locked. I'm told that in Access, I need to set
the isolation level to 0 (or Read Uncommitted). How do I do it in Access?
Need step-by-step hand holding on this. Thanks.

 

[Ralph]

1 (In Control Panel) Open the ODBC Data Source Administrator dialog box
2 Double-click the Informix data source
3 Click the Environment tab to display the Environment page
4 In the Isolation Level drop-down box, choose one of the following
Isolation levels:

Default
Read Uncommitted
Read Committed
Repeatable Read
Serializable

Click OK to save the value.