Are you trying to open a recordset from a command object (Set rs = 
cmd.Execute)? If that is the case, it did not work for me either! You 
might want to try opening the recordset directly using rs.Open. Make sure 
the CursorType is adOpenStatic and CursorLocation is adUseClient.

HTH,
Biju

> Hi all,
> 
> We are switching from an Access DB to SQL Server 7.0. My problem is that
> on our web site we are using the recordset property RecordCount and
> AbsolutePage and it works fine with access but with SQL Server it
> doesn't. I've been reading about it and I found out that not all
> provider support those property. right now the provider I use is
> SQLOLEDB. I would love to give you some code but I don't know what would
> be useful. What can I do to fix the problem?
> 
> Thanks!
> 
> --
> Martin Maurais
> Tribeworks, Web Administrator
> martin@t...
>  (xxx) xxx-xxxx
> 988 Market St. 8th Fl. SF, Ca 94102
> http://www.tribeworks.com
> 
>