Recent content by RoyM

  1. R

    Error Connecting to z/OS DB2

    How do I see which driver the datasets are pointing to? How can I re-load the DB2CLIO.DLL file? When I attempted to register it: c:\windows\sysem32\regsvr32.exe db2clio.dll I get an error window: The module "db2clio.dll" was loaded but the entry-point DIIRegisterServer was not...
  2. R

    Error Connecting to z/OS DB2

    Hi Sonic8, No, you are mistaken. The version is: "Microsoft Access 2016 MSO (16.0.8431.2046) 64-bit". Yes, I am referring to Windows Admin rights. I am a DB2 Admin. Regardless, I have looked at the ODBC connections and there is no place that I can find where I can select read-only or...
  3. R

    Error Connecting to z/OS DB2

    Hi, I'm getting an error when I attempt to connect to z/OS DB2 from MS Access. My PC is running Windows 64 and my MS Access 2016 is 64-bit. I have checked the ODBC DB2 64 drivers(?) by executing odbcad32.exe in the c:\windows\system32 directory, and can connect to the DB2 environment, DB2U...
  4. R

    The operation on the OLE object failed.

    I can work with that! Thanks isladogs and MajP
  5. R

    The operation on the OLE object failed.

    I have discovered that Microsoft Common Item Dialog has superseded Microsoft Common Dialog Box Library. I know that Common Dialog Box Library is inside file ComDlg32.ocx, but I don't know what file contains Microsoft Common Item Dialog. I've tried searching for an hour, but to no avail. Does...
  6. R

    The operation on the OLE object failed.

    Interesting. I've never used ShellExecute before. But there's no form? I am looking for something that is the equivalent to the CommonDialog function in the COMDLG32.OCX file. Isn't there something out there? If Microsoft no longer supplies it, then the entire Windows world would have to...
  7. R

    The operation on the OLE object failed.

    Great! I use the common dialog that everyone uses in every windows application to open a file. Please inform me of the new way to use it. Thanks
  8. R

    The operation on the OLE object failed.

    So Microsoft is no longer providing a DLL or OCX with methods in it which we can use to open files (MSComDlg.CommonDialog.1), etc.? Are you saying we each need to write our own equivalent to COMDLG32.OCX ? That's beyond my current skill level. I can understand Microsoft abandoning a specific...
  9. R

    The operation on the OLE object failed.

    I should also mention I am using Windows 10 Build 16299.
  10. R

    The operation on the OLE object failed.

    Yes, I am using "Microsoft Access 2016 MSO 64-bit. I don't know how to find out whether the COMDTL32.OCX file I loaded is 32-bit or 64-bit. The OCX file size is 138KB, the DLL file size is 1033KB. I saw that there is a regsvr32.exe in both System32 and SysWOW64. I registered the same OCX...
  11. R

    The operation on the OLE object failed.

    Hi, I registered COMDLG32.OCX using regsvr32.exe and was able to add "Microsoft Common Dialog Control 6.0 (SP3)" to the References in MS Access VBA. Yet, when I try to add a "CommonDialog Class" to my Form it raises the error: The operation on the OLE object failed. The OLE server may not be...
Top Bottom