Identify which row of a recordset I am on?

[Centrican]

Hi all,

I need to find out which row of a very large recordset I am currently on. My connection to the database has failed and I need to reconnect, which will mean starting my code again. Trouble is I don't want to do the upload twice.

If I can find out which row I'm on I can do a loop to miss out all the rows that I've already worked on.

I've tried using cursorlocation but I'm not sure that's working as it says 2 and that can't be right.

Any ideas?

 

[Trevor G]

What about adding a debug statement like this, just display the immediate window in your code screen and test it

Sub debu()
Debug.Print ActiveCell.Address

End Sub

 

[Centrican]

Sadly it's a recordset from an SQL query.

 

[Ruddles]

Is it .AbsolutePosition?

 

[Centrican]

Is it .AbsolutePosition?

I tried this and was told "-1" so i suspect not

It's driving me mad, I don't want to break out of the code as it spent 8 hours running already.

 

[Ruddles]

Are you sure you were actually moving through the recordset when the connection failed? You haven't forgotten to code a .MoveNext, have you? (I do this a lot!)

What does .PerCentPosition return?

 

[Centrican]

Thanks for trying to help guys; unfortunately someone turned the machine off on friday night so it ended up being a moot point. Instead of trying again I fixed the issue that was making it run slowly.

I'd still be interested in figuring out how to do this tho, everything I try returns -1 even when I know it is moving through the recordset.

 

[Ruddles]

Are you using DAO/ADO to submit the SQL query and then moving through it using .MoveNext?

If so, as soon as you open the recordset, try doing a .MoveLast immediately followed by a .MoveFirst before you start going through the recordset. (It can take a few moments for a large database.) Does that kick-start .AbsolutePosition into working properly?