Update fields in Datagrid 6.0 component

Hi all,

This is my first time i work with the datagrid component ... i see all my data in the grid, but i can't change (update) the values in the grid? In the properties of the datagrid i cheked AllowUpdate, AllowAddNew, allowDelete.

Any one an idea?
connAccess.Open "Provider= Microsoft.jet.OLEDB.4.0;Data Source=" & App.Path & "\mydb.mdb;"
connAccess.CursorLocation = adUseClient
rsData.Open "select field1, field2, field3 from tbl_data where not isnumeric(field1)", connAccess
Set DataGrid1.DataSource = rsdata

Open in new window

LVL 4
WimAsked:
Who is Participating?
 
game-masterConnect With a Mentor Commented:


good morning!

is there an error message?

make sure the recordset locktype is adLockOptimistic.

try sumthing like this...

rsData.Open "select field1, field2, field3 from tbl_data where not isnumeric(field1)", connAccess, adOpenDynamic, adLockOptimistic


i hope i could give u some idea...
game-master
0
 
WimAuthor Commented:
That's it!
Thanks a lot
0
 
game-masterCommented:


I'm glad i could help! :-)



game-master
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.