[AccessD] Data from Informix to Access - dirty reads?

Hi Tom:

You may be right as I have never used a 'read-only' recordset but by setting
the recordset to 'static' will give the same features and superior
performance....Second only to 'forward-only'. 

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tom Bolton
Sent: Thursday, February 03, 2005 2:11 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Data from Informix to Access - dirty reads?

Jim

If the cursor lock type is set to read-only, you can still scroll through it
but will raise an error if you try to edit it.

The ability to read through the cursor depends on it's type - you can read
through all of them, apart from a forward-only cursor where as the name
suggests you can't scroll backwards i.e. rs.MovePrevious, rs.MoveFirst.

Cheers
Tom




-----Original Message-----
From: Jim Lawrence [mailto:accessd at shaw.ca] 
Sent: 03 February 2005 06:03
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Data from Informix to Access - dirty reads?

Hi Mark:

If you set the recordset to read-only (adLockReadOnly) how do you expect
read through the recordset. Try something like:

rsRecordset.Open strSQL cnConnection, adOpenStatic, adLockOptimistic

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Wednesday, February 02, 2005 10:59 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Data from Informix to Access - dirty reads?

Thanks for the feed back...but it didn't change anything.  Something else 
I've noticed...I can use the same SQL criteria, except select a different 
field and I can loop through those records without a problem...it just 
occurs when I try to display or reference the case_id when it is more than 2

digits?

I'm thoroughly confused at this point...and once I get it to loop through 
the recordset...How do I get the recordset into a local/temp table?  
Although...without the case_id...the last questions doesn't really matter

Thanks,

Mark