AS/400 via Access, update query

Antser

5 pts.

Tags:

AS/400

AS/400 database

AS/400 Query

Microsoft Access queries

Hi all,

My DB is on AS/400 and I use Microsoft Access to run queries. However, whenever I try to run an update query, I receive the following error message:

"[IBM][ISeries Access ODBC Driver][DB2 UDB]SQL7008 - table in library not valid for operation. (#-7008)"

Any idea what is missing? Thanks in advance!

Software/Hardware used:
WIN7

Asked: February 15, 2011 12:18 PM Last updated: September 15, 2013 2:44 PM

Answer Wiki

Last updated: September 9, 2013 4:31 PM GMT

Michael Tidmarsh62,155 pts.
History
Contributors
- Ordered by most recent
- Michael Tidmarsh62,155 pts.
- Mariodlg2,790 pts.

Thanks. We'll let you know when a new response is added.

Hi, look at this thread right here:

SQL7008

Regards.

Discuss This Question: 4 Replies

Dickdono Feb 17, 2011 8:31 AM GMT

It has been a while since I've used MS Access to update a table/file on AS/400, but I seem to remember that to UPDATE a file (like via an update query), the file on the AS/400 has to have a unique key.

35 pointsBadges:

report
CharlieBrowne Sep 9, 2013 10:11 PM GMT

Check the authority.

You may have read access but not update.

62,340 pointsBadges:

report
bhannah Sep 15, 2013 2:06 PM GMT

It may also be that it is not translating the data correctly. Is the database an access database? What format is it in? I used to use access to query a data base on our AS/400 and I had to remember the data was not stored in ASCII format. It had to be translated to and from a different format to usable.

4,090 pointsBadges:

report
philpl1jb Sep 15, 2013 2:44 PM GMT

This question is over two years old.

54,090 pointsBadges:

report