Table does not update record in MS ACCESS

[Tufail Ahmad]

i use VB 6.0 with MS Access as a database. With the insertion in table1 i use to update a counter (N+1, ....) in table2. but some time table2 does not update its value and repeat the previous value. e.g if previous value is 2854 then it should be updated to 2855 Help please

[Lost User]

It would be difficult to answer your question without looking into your code.

[Tufail Ahmad]

Code is very simple and i know how to code for insertion into database. str="Update table2 set field1=val1, field2=val2 Where condition" set rs=cn.execute(str) but some time it misses to update a record.

[Lost User]

Change your number-field to an auto-numbering field[^]. That way the number will increase itself, every time that you insert a table - without the need to track the highest number in a separate table.

I are Troll :suss:

[Dave Kreskowiak]

You should be using autonumbering fields for your primary keys. Also, when you insert a record into Table1, you need to retrieve the ID that record got in the table, then use that ID in your query to update Table2.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007, 2008
But no longer in 2009...

[Lost User]

Tufail Ahmad wrote:

Update table2 set field1=val1, field2=val2 Where condition

This code will NOT insert anything into table2, ever wondered why ?