CursorType issue with .mdb and Excel VBA, ADO
- From: "TempestFyre" <TempestFyre@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 22 Aug 2005 03:03:02 -0700
I'm in the process of trying to implement ADO in some new Excel apps, and
lead others here away from DAO, so that my future scaling to a SQL server may
be less frustrating. However, I've been unable to retrieve anything other
than a forward-only cursor from ANY .mdb we use. I need a static cursor.
Have set the props for the recordset, I can then write the cursor/lock
properties to a work*** before the recordset is opened, and then write them
again, following the recordset's retrieval. They always revert back to
forward-only!
I thought it is possible to use static cursors with Jet 4.0. Is this not
true?
Any ideas would be nice.
..mdb created using Access 2002 (or 2003, for some), Excel 2003, ADO 2.8
Jet 4.0 SP8
Thank you in advance.
.
- Follow-Ups:
- RE: CursorType issue with .mdb and Excel VBA, ADO
- From: TempestFyre
- RE: CursorType issue with .mdb and Excel VBA, ADO
- Prev by Date: Re: How to get ADO 2.8 to obey HDR=NO ?
- Next by Date: Excel Euro Symbol Issue
- Previous by thread: Does ADO work on 64 bit platforms
- Next by thread: RE: CursorType issue with .mdb and Excel VBA, ADO
- Index(es):