In Access 2002 (project) I have used the following code in order to
use a server side cursor,
Set cnnClientFrm = CurrentProject. Connection
cnnClientFrm.Cu rsorLocation = adUseServer
Do you need to configure anything on the SQL server side to make this
work or make it work more efficently?
The reason I ask is that I just have tried switching this between
adUseServer and adUseClients 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.
Thanks,
Bob.
NB: I posted this originally in the Access group but got no replied so
I am reposting here.
use a server side cursor,
Set cnnClientFrm = CurrentProject. Connection
cnnClientFrm.Cu rsorLocation = adUseServer
Do you need to configure anything on the SQL server side to make this
work or make it work more efficently?
The reason I ask is that I just have tried switching this between
adUseServer and adUseClients 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.
Thanks,
Bob.
NB: I posted this originally in the Access group but got no replied so
I am reposting here.