IBM Power Ideas Portal


This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas

  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Add a new idea Subscribe
Status Is a defect
Workspace IBM i
Categories IBM i Access Family
Created by Guest
Created on Oct 17, 2025

RELATED IDEAS

OLEDB error messages from ACS package V11.28.00 are not properly returned to Access VBA

We are using Access 2019 VBA to connect to an IBM i (S914) database via OLEDB. Previously, we used "IBM i Access for Windows 7.1.1500" (IAW OLEDB), and error messages were returned correctly to Access VBA.


Now, we are testing with "IBM ACS Application Package V11.28.00" (ACS OLEDB), and we encounter the following issues:


1.Connection errors


2.INSERT statement with duplicate key error


3.UPDATE statement with NOT NULL constraint violation


However, in all cases, the error message returned to Access VBA is simply: "Execute method failed: '_Command' object"


On the IBM i side, we can confirm the correct error details via WRKACTJOB → QUSRWRK/QZDASOINIT → Job Log.


This behavior did not occur with IAW OLEDB, so we suspect that ACS OLEDB is not properly passing detailed error messages back to the client.


We would like to request improvement in ACS OLEDB so that detailed SQL error messages are correctly returned to Access VBA, as they were with IAW OLEDB.

Idea priority High
  • Guest
    Oct 24, 2025
    The proper channel to address the issue is the IBM Support portal ( http://www.ibm.com/support ).
    Open a case, specifying "IBM i" as the product. It will be routed to the appropriate support team.
    The support team will analyze the case, work with you to gather any additional details, and engage the development team to work toward a resolution.
    Reply
  • Guest
    Oct 24, 2025

    Thank you for your comment. The issue being raised is not a feature installed with ACS, but an optional feature, so I believe it is appropriate to discuss it here. Essentially, it is a defect, so it is not a problem that can be found on the support site. Furthermore, I am pointing out that despite the version already being 11.28.00 and having made significant improvements, it still cannot handle basic error messages. Could you please tell me the URL where improvement requests can be submitted?

    Reply
  • Guest
    Oct 23, 2025
    The IBM Ideas web site is for making requests for additional features.
    For issues with existing features, please open a ticket with IBM Support so that your issue can be further investigated.
    https://www.ibm.com/support/pages/ibm-i-access-support

    IBM Power Systems Development
    Reply

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.