CommandType = adCMDTable
CursorLocation = adUseServer (If I use Clinet it Freezes)
CursorType = OpenDynamic
RecordSource = vMaster (This is a view in SQL)
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=TPO;Data Source=slc-custsql

I can use the following code and it is really fast:

Dim RC as Recordset
Set rc = New Recordset
rc.Open "Select * from Table", "DSN = TestSQL"


One other side note:
I can not use the RC. AbsolutePosition in the code above. Serge told me to add the RC.cursorLocation = adUseClient. However when I do, it is soooo slow. If I use adServer it is still very slow but not as slow as adUseClient. It does, however, give me the absolutePosition value.