Greetings.
On my previous project, I have used the adodc.
According to a friend of mine, he said that using a data control is easier (implementation/coding matter).
I am still very confused with the difference of this 2 controls. :-|
I am not sure which connection string is to apply for which of those 2 controls.
Private Sub Form_Load()
Dim con As New ADODB.Connection
Dim rs As New ADODB.Recordset
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb;Persist Security Info=False"
con.Open
rs.Open "select com_name from competency", con, adOpenKeyset, adLockOptimistic
End Sub
Is the above code for a Data control?
Alright, about DSN, I have to set up the DSN for an adodc.
What about Data control? Do I have to create a DSN too?
Please advise. :confused: