Home All Groups Group Topic Archive Search About

Update information in Table

Author
26 Nov 2007 7:27 PM
Arlene
Help please, I am trying to update information from one program to another. 
I have a payroll system and want to update the information in the employee
table to the information in a production program.  I have made sure the
information is in the right formats and now get a message that ODBC insert on
a linked table has failed.  What can I be doing wrong I have done this in
other programs is something blocking me?  If so what could it be, I had
problems at the beginning and got the usual cannot update x number of records
but I corrected all the number and text formats as well as included any
required information now I get this message.  Thanks

Author
27 Nov 2007 2:33 AM
John W. Vinson
On Mon, 26 Nov 2007 11:27:00 -0800, Arlene <Arl***@discussions.microsoft.com>
wrote:

>Help please, I am trying to update information from one program to another. 
>I have a payroll system and want to update the information in the employee
>table to the information in a production program.  I have made sure the
>information is in the right formats and now get a message that ODBC insert on
>a linked table has failed.  What can I be doing wrong I have done this in
>other programs is something blocking me?  If so what could it be, I had
>problems at the beginning and got the usual cannot update x number of records
>but I corrected all the number and text formats as well as included any
>required information now I get this message.  Thanks

Please post your code. It's impossible to debug an error we can't see.

             John W. Vinson [MVP]

AddThis Social Bookmark Button