Problem with updating a table on iSeries from Access Query

Anthony6890
Anthony6890 used Ask the Experts™
on
Hi everyone, I'm currently trying to update fields on an iSeries table within Microsoft Access.  I currently have an ODBC connection setup to the iSeries, but when I attempt to update the fields I get the error in the attached screenshot.

Has anyone seen this before, or have any suggestions as to what I'm doing wrong?

Thank you in advance.
Error.doc
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I was able to figure it out.  Here's what I needed to do:

Assuming you are looking at your DSN in the ODBC Manager applet within
Control Panel...

Select your DSN and press the [ Configure ] button.

On the "Server" tab press the [ Advanced ] button.

For the "Commit Mode" there will be a few choices. You want "Commit
immediate (*NONE)".

I got this information from this site:

http://www.pcreview.co.uk/forums/odbc-export-iseries-t3606347.html

Worked like a charm after that.

Author

Commented:
I was able to figure it out after doing some research on the internet.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial