Good Morning Everyone (or evening as the case may be),
Just a quick question about the cursor location property of an ADO
recordset object.
adUseServer is the default, has anyone ever switched it to adUseClient to
use the .Sort and .Filter methods of the ADO recordset? I am helping
another programmer convert an application that uses Access datafile to PG.
I've always just left it adUseServer and wrote various SQL statements to
fill my recordsets, but he has extensive use of .Sort and .Filter in his
code.
I've checked out some websites and they all say that adUseServer is a real
resource hog on the server, but that's fine with me because the DB is on a
slick machine. Can anyone offer any advice?
thanks in advance
Corey W. Gibbs