[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
-------------- next part --------------

The contents of this message and any attachments are the property of Donns Solicitors 
and are intended for the confidential use of the named recipient only.  They may be legally
 privileged and should not be communicated to, or relied upon, by any other party without 
our written consent.  If you are not the addressee, please notify us immediately so that we 
can make arrangements for its return.  You should not show this e-mail to any person or
 take copies as you may be committing a criminal or civil offence for which you may be
 liable.  The statement and opinions expressed in this e-mail message are those of the 
writer, and do not necessarily represent that of Donns Solicitors.  Although any files attached
 to this e-mail will have been checked with virus protection software prior to transmission, 
you should carry out your own virus check before opening any attachment.  
Donns Solicitors does not accept any liability for any damage or loss which may be caused 
by software viruses...