ODBC - Need to set it to Read Uncommitted

  • Thread starter Thread starter june.dalde
  • Start date Start date
J

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.
 
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.
 
Back
Top