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.
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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 4  Replies
Check the authority.
You may have read access but not update.
This question is over two years old.