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

  • Follow


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 ?????

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/200704/1

0
Reply Gurdeep 4/12/2007 2:39:30 PM

Gurdeep Toor wrote:
>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 ]

-- 
Message posted via http://www.accessmonster.com

0
Reply Gurdeep 4/12/2007 2:45:41 PM


"Gurdeep Toor via AccessMonster.com" <u33223@uwe> wrote in message 
news:7098a94fa0b2a@uwe...
> 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 ?????
>
> -- 
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access/200704/1
> 

0
Reply i_takeuti 4/12/2007 9:47:48 PM

2 Replies
1485 Views

(page loaded in 0.06 seconds)

Similiar Articles:
















7/23/2012 9:34:57 PM


Reply: