UPDATE COMMAND for ACCESS 2007 DATABASE

Question

Hope it will be simple but I am unable to UPDATE my ACCESS 2007 Database source = "C:\Elec Power Calculator\Elec Power Calculator\DataBase.accdb". The Fields of the TABLE which should be Uptated  is "CALC".

It would be appreciated, If someone please solve my this issue through giving me code. Below table is showing the names of Fields get values from Textboxes.

FIELDS of Table (Calc)	TEXTBOXES used on VB.Net
SUM	DISPLAY.TEXT
KV	TXTKV.TEXT
KVA	TXTKVA.TEXT
P_KVA	TXTDFKVA.TEXT
C_AMP	TXTTAMP.TEXT
DB_Current	TXTMCCB.TEXT
VOLTAGE_D	TXTVD.TEXT
CORE_34	TXT3CORE.TEXT
CORE_2	TXT2CORE.TEXT

---

/\ |_ |-| /\ |) |

Answer 1

Hi Al,

Not sure how much you know about ADO.NET technology, please take a look at: http://msdn.microsoft.com/en-us/library/h43ks021.aspx

Also, check on this "How do I..." FAQ.

http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/c27538e2-44d7-4cb9-9141-ed7ee733bf80

Try to write some code, and please let us know if you need further help.

Have a nice day,

---

Kee Poppy [MSFT]
MSDN Community Support | Feedback to us