Insert,Update Data in sage (MS Access Linked tables) using Vb.net form

[Gurdeep Toor via AccessMonster.com]

Hi folks,
I am developing application using vb.net which requires integration with SAGE
LINE 50 (Accounting software ) V11... The data which SAGE is using is MC
ACCESS 2003 database... with linked tables in it... Now I Have developed the
Sage connection using ODBC which works fine when reading the record but
cannot Add or Update record into the Linked tables.... When i debug the
program the error is at the line where it has...
<br>
MyodbcCommand.ExecutenonQuery()
<br>
Can anybody Help ?????

 

[Gurdeep Toor via AccessMonster.com]

Hi folks,
I am developing application using vb.net which requires integration with SAGE
LINE 50 (Accounting software ) V11... The database which SAGE is using is MS
ACCESS 2003 database... with linked tables in it... Now I Have developed the
Sage connection using ODBC which works fine when reading the record but
cannot Add or Update record into the Linked tables.... When i debug the
program the error is at the line where it has...
MyodbcCommand.ExecutenonQuery()
Can anybody Help ?????

The Error is [Syntax error ]

 

[i_takeuti]

Hi folks,
I am developing application using vb.net which requires integration with
SAGE
LINE 50 (Accounting software ) V11... The data which SAGE is using is MC
ACCESS 2003 database... with linked tables in it... Now I Have developed
the
Sage connection using ODBC which works fine when reading the record but
cannot Add or Update record into the Linked tables.... When i debug the
program the error is at the line where it has...
<br>
MyodbcCommand.ExecutenonQuery()
<br>
Can anybody Help ?????