best one from adopendynamic and adopenstaic in vb6.0 while making connection with access

See more:

VB6

dear sir

i am using vb6 and i made connection with databse using adopendynamic and adopenstaic
example


Dim gcnAs New ADODB.Connection
Dim prs As New ADODB.Recordset
Debug.Print strSQL
prs.Open strSQL, gcn, adOpenStatic, adLockOptimistic

and
Dim gcnAs New ADODB.Connection
Dim prs As New ADODB.Recordset
Debug.Print strSQL
prs.Open strSQL, gcn, adOpenDynamic, adLockOptimistic



which the best to use please tell me. i using my vb application on network sharing the common database and tell me the better way to use.