In Access is there anything more to using a server side cursor other
than
Set cnnClientFrm = CurrentProject.Connection
cnnClientFrm.CursorLocation = 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.