running macro with VBS suddenly some views don't work

SOLVED

Have a v2018 PU2 macro running fine for months; suddenly 2 view lines of code do not work

I get

run-time error '-2147467259 (80004005)'
Method 'OpenView' of object 'IAccpacDBLink' failed

here is the punch line

Public OEHdr As AccpacCOMAPI.AccpacView
Public OEDet1 As AccpacCOMAPI.AccpacView
Public OEDet2 As AccpacCOMAPI.AccpacView

    mDBLinkCmpRW.OpenView "OE0520", OEHdr
    mDBLinkCmpRW.OpenView "OE0500", OEDet1
    mDBLinkCmpRW.OpenView "OE0740", OEDet2

OEHdr and OEDet1 no longer work, OEDet2.... OEDet12 work fine

running macro under Sage 300 and NOT using  vbs works fine

Parents Reply Children
  • 0 in reply to Dana B. Stidsen

    yes on my own station it works; they key part is record a macro in Sage 300 going into the OE screen and change a simple field.  if you run the macro then under Sage 300 it creates the view; if you edit the macro outside of Sage 300 the view does not create and only the header and detail1 does not work, other detail views work.

    I am going through users and Server I.T. people to find out who installed Office ( and maybe other stuff) on Dec 12 and why; so far no one confesses. Does not sound like a normal Microsoft messing with VBA - messing only 2 views of 12 - strange

  • 0 in reply to Ron Boyd
    SUGGESTED

    Sounds like definitely an environment issue.  All of my macros I've done always run inside of Sage 300 so I've not faced this issue.

    Please let us know what you find.

    Dana

  • +1 in reply to Dana B. Stidsen
    verified answer

    fixed now

    3rd party web software  had attached to OE and when I went to create OEHDR view it tried to make their views also; but their software is web based and doesn't even need to attach to standard OE screen.

    modified CSAPP table to change their abbreviation on the OE lines to something like XX that is not used and then OE cannot communicate with this software

    found this out by using RVSPY when macro run inside Sage and outside Sage just on create command for OEHDR view.