Question Odbc connection

[aservos]

Dear all
I am trying to execute an append query in MS Access 2007 (the tables I am using belong to an ibm/as400 database), and i am getting the following error message:
ODBC--insert on a linked table 'library_table' failed.
\\[IBM\\]\\[iSeries Access ODBC Driver\\]\\[DB2 UDB\\]SQL7008 - table in library not valid for operation. (#-7008)
Any idea what i should do to overcome the problem?
Thanks in advance

 

[Rabbie]

See this link for a possible solution

 

[aservos]

Dear Rabbie

I view the link. However, I think that the solution might be simpler.
I imagine it has to do with the settings of the DSN.
There is something I am missing though.

 

[boblarson]

If trying to append to the non-access table(s) you must make sure that those tables have a primary key defined.

As for the DSN - if you go follow through the configuration you should get a TEST CONNECTION button and if it works then it is likely the lack of a primary key as Access needs that to update external tables.

 

[aservos]

Bob

the non-Access table does have a primary key.
There is something I did not mention on my previous posts that might be helpful.
My pc runs Win7.
I can execute the append query without problem to a pc running WinXP.
(The DSN settings are identical !!! to both pcs).

Thnx