How to update only particular column in DB(MS-Access)

Question

Hi guys,

I would like to learn the best way to update the database.

The situation is:

I'm having some textboxes(> 3) on a form. I need to update the db columns with the text from textboxes which means the db has 3 columns, repressents each textbox.

Let say only textbox2 is edited. How should i update only the column related to textbox2 and not looping the whole columns to find where the edits need to be updated?

Any idea guys?

Sam Hobbs · Answer

I think your question is vague but you are hoping for a specific answer. There are many ways to do what you are asking but if we give you a specific answer it is likley it won't be compatible with the way you are reading the database and such. Most experienced programmers would use the tools that Microsoft provides and let the software take care of details. The article Database Table Update in a DataGridView without Writing Code I wrote. You can do something similar to make a form that edits just one record at a time. If you want something specific to what you already have, you need to be more specific in your description.

skunkhead raj · Answer

so, we can't simply to update the textbox2 without updating the other 2 textboxes?

Suthish Nair · Answer

Let say only textbox2 is edited. You changed textbox2 old value to new, so what will be the values in textbox1 and textbox3 at the same time? That remains the same. So just do the updation of that columns also, same value get updated.

How to update only particular column in DB(MS-Access)

Answers (3)