
question for DataGrid and MS Jet 4.0 OLD DB Provider
Using MS Jet 4.0 OLD DB Provider under VB 6.0, it is found that I am
unable to modify the
content of column on the Datagrid (SP3) if the column is binded to an
alias field and got
the message "The column is read only".
However, this problem doesn't occur if using MS Jet 3.0 OLD DB provider
and MS access 97
database file.
Is there any way to resolve it ?
Thanks in advance.
Rgds,
Ivan Cheng
Program setting as below :
Create a new Data_envirnment with following setting :-
Connection :
Provider - MS Jet 4.0 OLD DB Provider
Advance - Read/Write and Share Deny None
Command :
Name - tmp
Connection - cnn
SQL statment - "select *, description + ' ' +
packing as name from `tmp-invoice-items` "
Advanced - batch Optimistic
Cursor Type - static
Cursor Location - Use client side cursor
Data file : db2.mdb (created by MS Access 2000 or MS Access
97)
Datagrid (SP3) : name - Datagrid1