Access 2000 Recordset issues

N

Nick

I am using the following code (to write data to a file)
in the OnClick property of a button:

Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset

Set cn = CurrentProject.Connection
Set rs = New ADODB.Recordset

rs.Open "Select * from .....
Do While rs.EOF = False
--
--
WriteLine(rs.AbsolutePosition)
WriteLine(rs.RecordCount)
rs.MoveNext
Loop
-------------------------------------
I'm not getting the expected values for AbsolutePosition
and RecordCount. These come up as 1 for all records when
I run this app/code in Access 2000 (windows ME). The
code works fine on my other machine w/ Access 2002 (XP
professional)..... Any suggestion on how can I get the
correct values in A2000?

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top