Skip to Content
author's profile photo Former Member
Former Member

Access calls SAP-RFC-function modules

Hi experts,

i have some trouble with an Access application. Access get some data from SAP via SAP-RFC-function modules. The whole function is programmed in MS-Access. I used the dll-/VBA-references of the SAP-GUI within Access. This still works since 2005. Now Access is updated to Version Access 2007 (MS-Office 2007) with SAP-LOGON 7.1 and I can not create the connection to SAP any more.

Now my question: Which libraries - SAP or Access - i have to implement in my Access-VBA-project / Access-application to connect Access to SAP and get the data sets from my SAP-RFC-function modules? Or is there any other chance to get the data from SAP to Access?

regards

Peter

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Sep 23, 2009 at 09:12 AM

    It should still work, did you check sap notes?

    If yes, please explain your connection method.

    For example one method is to use:

    - SAPLogonControl object: C:\Program Files\SAP\FrontEnd\SAPgui\wdtlog.ocx (name "SAP Logon Control")

    - SAPFunctions object: C:\Program Files\SAP\FrontEnd\SAPgui\wdtfuncs.ocx (name "SAP Remote Function Call Control")

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 06, 2011 at 09:18 PM

    Hello,

    my solution with the SAP 7.20 Patchlevel 7 GUI and Office 2010 32 bit (without SP1). Be sure that you have registered the right OCX and DLL. There are some Differences between the 32 bit and 64 bit OS of the Server.

    32 bit Server:

    regsvr32 c:\program files\sap\frontend\sapgui\wdobapi.ocx

    regsvr32 c:\program files\common files\sap shared\wdtlog.ocx

    regsvr32 c:\windows\system32\librfc32.dll

    regsvr32 c:\program files\sap\frontend\sapgui\wdtaocx.ocx

    regsvr32 c:\program files\sap\frontend\sapgui\wdtfuncs.ocx

    64 bit Server:

    regsvr32 c:\program files (x86)\sap\frontend\sapgui\wdobapi.ocx

    regsvr32 c:\program files (x86)\common files\sap shared\wdtlog.ocx

    regsvr32 c:\windows\SysWOW64\librfc32.dll

    regsvr32 c:\program files (x86)\sap\frontend\sapgui\wdtaocx.ocx

    regsvr32 c:\program files (x86)\sap\frontend\sapgui\wdtfuncs.ocx

    After registered the files you have to enter them into the references of the Access Code. The new Microsoft Security doesnu2019t let you create a ActiveX Object, so you create a normal Access Button and put your RFC Code into the click event. Now it should work again, important is only that you have entered the right reference to the registered ocx and dllu2019s.

    Best regards

    Manfred

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 29, 2014 at 09:43 AM

    What installations are necessary for the .wdo* and .wdt* files to appear in the SAP directory? I currently only got .wdk* files in the specified directory...

    best regards

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.