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
  • +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.

Children
No Data