[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 622
  • Last Modified:

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

0
Wim
Asked:
Wim
  • 2
1 Solution
 
game-masterCommented:


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

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now