Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#4 Microsoft Access Editing in DBGrid

open
nobody
None
5
2004-02-16
2004-02-16
Gregory A. Dunn
No

Hello,

I am trying to connect to a Microsoft Access table and
allow editing from a DBGrid. I cannot seem to make this
work. You can hit F2 and try to enter characters but
they dont show up in the field. I have tracked it down
to being caused by the Field.ReadOnly flag being true.
Is there any way to allow editing from a DBGrid with
Microsoft Access?

I am using the following structure:
DBGrid
DataSource
ClientDataSet
DataSetProvider
SQLQuery

I have also tried SQLTable.

I can make updates by executing UPDATE SQL
statements but I just can't edit through the DBGrid.

I also have the same problem if I try to edit in the grid
with your ODBCExplor program.

Do you have any suggestions.

Thanks,
Greg Dunn
Eagle Research Corporation
304-757-6646

Discussion

  • Logged In: YES
    user_id=644745

    It is problem of odbc driver. It marked fields as readOnly=True.
    You should mark it as readOnly=False.

     
  • Logged In: YES
    user_id=644745

    It is problem of odbc driver. It marked fields as readOnly=True.
    You should mark it as readOnly=False.