question for DataGrid and MS Jet 4.0 OLD DB Provider 
Author Message
 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



Mon, 29 Apr 2002 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Create Jet 3.5x DB with OLE DB Provider 4.0

2. Data Environment/Jet 4.0 OLE DB Provider problem

3. OLE DB Provider 4.0 for Jet SLOW

4. OLE DB Jet Provider 3.51 or 4.0 ?

5. JET 4.0 ole db provider

6. DataGrid Control and ADO Jet 4.0 Provider

7. OLE DB Provider 4.0 for Jet SLOW

8. Jet DB Performance (Jet 3.51 vs. Jet 4.0)

9. Replace OLEDB provider Jet 3.51 with Jet 4.0

10. Update/delete of dBase/Paradox DB using MS Jet 4.0

11. MS Jet 4.0 OLE DB & Win 2000

12. ODBC provider vs MS SQL provider (OLE DB)

 

 
Powered by phpBB® Forum Software