Server side cursors

[Robert Hogan]

In Access is there anything more to using a server side cursor other
than

Set cnnClientFrm = CurrentProject. Connection
cnnClientFrm.Cu rsorLocation = adUseServer

Do you need to configure anything on the server side to make this work
or make it work more efficently?

The reason I ask is that I just have tried switching this on and off
on a connection that then is used to load a particularly large
recordset and it doesn't seem to make any performance difference that
I can determine.

I'm going try again once everyone leaves for the day, maybe the lack
of result was due to extra server activity at some point.

I am using Access project.

Thanks,

Bob.