#4 Microsoft Access Editing in DBGrid

[Gregory A. Dunn]

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

[Vadim V.Lopushanskiy]

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.

[Vadim V.Lopushanskiy]

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.