Jim Lawrence
accessd at shaw.ca
Thu Feb 3 05:52:04 CST 2005
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