Oops...I originally posted this in wrong forum
I have an ADODC control bound to DataGrid and I am trying to update it but it will not let me.
Here is an example of my code...any ideas why this doesn't work?
'Connect and Retrieve Data using Jet 4.0
SQL = "SELECT * FROM table WHERE PrimaryID = " & PrimaryID & " ;"
Adodc1.CursorLocation = adUseClient
Adodc1.LockType = adLockOptimistic
Adodc1.CursorType = adOpenStatic
Adodc1.RecordSource = SQL
Set DataGrid1.DataSource = Adodc1
DataGrid1.AllowUpdate = True
'Update Datagrid after Edit