SAP-RFC Connection Error Messages Using VB

[mpdsal]

Is there some VB code or commands I can add to see error statements or authorization issues? For example I can't connect because I may be missing some authorizations for object S_RFC in SAP. I am looking for something similar to SU53 to check missing authorizations, if any. Is this possible to do using VB? We are using SAP Basis component 620.

FYI, I am connecting using wdtfunc.ocx program within MS Access 2007.

Thanks

Mark

 

[mdlueck]

FYI, I am connecting using wdtfunc.ocx program within MS Access 2007.

I think you need to search based on that OCX control file. The fact that you are using Access is secondary to obtaining good documentation / support for your OCX control.

 

[mpdsal]

Thanks! I will do that.

I used this forum because I am using Access to try and connect to SAP and download tables for analysis. I'll try the ocx search.

Thanks

Mark

 

[Rank Am]

One of our acquired subsidiaries run SAP at their plant and the guys use this to create the links to our corporate MS Access based Safety and Operational Reporting and CMMS system and Oracle bean counting app

http://www.samsole.com/sesapedm/sec.html

This seemed to work well though I wasn't directly involved - apart from providing them with our data models

You can also generate CSV hand off files associated with XL from SAP and then get them into access via the linked table manager - we use this to close out work that is not done through the work order system - i.e. Work Order Number can't be done until Items X,Y and Z have been isolated by an operator (SAP is a nightmare for such things)

I know they had huge issues with wdtfunc.ocx, as it is not properly documented and doesn't relay any of the SAP error messages so it's a constant shot in the dark - a lot of the time its table access issues in SAP rather RFC authorisation.