Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Insert using Micorosft Access 2000

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • rv_ooty@hotmail.com
    replied
    Insert using Micorosft Access 2000

    First check if your physical file is journalled. Otherwise you will get the same error and insert or update will not work. if you have CAE V4R4 and above means CAE supports ADO2.0 standards. otherwise only ADO1.5 standard. So no insert or update on AS400 from windows - forget it or ask IBM.

    Leave a comment:


  • Guest's Avatar
    Guest replied
    Insert using Micorosft Access 2000

    Hi, I have linked my AS/400 File in Access. When I am trying to enter the data in the file, I got the following error ODBC--insert on a linked table MyTable failed. [IBM][Client Access Express ODBC Driver 32 bit][DB2/400 SQL]SQL7008 MyFile not valid of operation (#-7008) My ODBC-DSN have Read/Write Option Selected. I am using Client Access V5.1. Thanks Shafiq

    Leave a comment:


  • Guest's Avatar
    Guest started a topic Insert using Micorosft Access 2000

    Insert using Micorosft Access 2000

    Does the file have a unique key on it, I believe it is necessary in order to do updates through ODBC. Scott Mildenberger
Working...
X