Documents on MSDN report AbsolutePosition only works with dynasets or snapshots.
I have a DAO recordset defined as
Set rs = dbs.OpenRecordset(MySQL)
where MySQL is a valid SELECT ... FROM ... WHERE ... ORDER BY SQL string
(1) How do I know that rs is a dynaset or a snapshot? Here's why I ask...
After defining rs, the following are executed
rs.MoveLast
rs.MoveFirst
While on the first record in rs, I run the following...
debug.print rs.AbsolutePosition
... and the value 1 is printed in the immediate window.
(2) Could there be some setting in Access that causes AbsolutePosition to be 1-based instead of 0-based?