Pastel Partner Runtime Error 2147217887

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Mullet
    New Member
    • Jul 2022
    • 5

    #1

    [Question] Pastel Partner Runtime Error 2147217887

    Hi Guys

    I have had this before around 4 or 5 years ago and Pastel logged on to repair some incorrect number input I think

    Not sure how to repair this. Only happens on the 1 company.

    Any helpful ideas?

    Thanks in advance
  • Neville Bailey
    Diamond Member

    • Nov 2010
    • 2786

    #2
    The error occurs when there is a table with invalid date. This usually occurs when you trying to access the Explorer.

    You can disable the Explorer for the user getting the error. You can do so whilst logged on the company with a password that does not give the error and has access to Setup Users and Passwords. To set the user to use Navigator go to Setup…Users / Passwords…Users, select the correct user and untick "Auto Invoke" for Navigator.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

    Comment

    • Mullet
      New Member
      • Jul 2022
      • 5

      #3
      Thanks Neville, but it does it on all users? and only on 1 company. I have tried all the users

      Comment

      • Neville Bailey
        Diamond Member

        • Nov 2010
        • 2786

        #4
        There's a possibility that the database contains an invalid date, which would need to be fixed with a database editor.

        Can you send me a backup of the company so that I can have a look at it? Once I have figured out where the problem is, we can make arrangements for me to fix your live database.
        Neville Bailey - Sage Pastel Accounting Consultant
        www.accountingsoftwaresupport.co.za
        neville@accountingsoftwaresupport.co.za
        IronTree Online Solutions

        "Give every person more in use value than you take from them in cash value."
        WALLACE WATTLES (1860-1911)

        Comment

        • Mullet
          New Member
          • Jul 2022
          • 5

          #5
          Thanks Neville

          Dropbox Link ok for the file?

          Comment

          • Neville Bailey
            Diamond Member

            • Nov 2010
            • 2786

            #6
            Yes, that will be fine.

            Please let me know the password as well.
            Neville Bailey - Sage Pastel Accounting Consultant
            www.accountingsoftwaresupport.co.za
            neville@accountingsoftwaresupport.co.za
            IronTree Online Solutions

            "Give every person more in use value than you take from them in cash value."
            WALLACE WATTLES (1860-1911)

            Comment

            • Mullet
              New Member
              • Jul 2022
              • 5

              #7
              Sent

              Password on the link

              Thanks in advance

              Regards
              Colin

              Comment

              • Neville Bailey
                Diamond Member

                • Nov 2010
                • 2786

                #8
                Hi Colin,

                Which version of Pastel are you using?
                Neville Bailey - Sage Pastel Accounting Consultant
                www.accountingsoftwaresupport.co.za
                neville@accountingsoftwaresupport.co.za
                IronTree Online Solutions

                "Give every person more in use value than you take from them in cash value."
                WALLACE WATTLES (1860-1911)

                Comment

                • Mullet
                  New Member
                  • Jul 2022
                  • 5

                  #9
                  Version 14

                  Comment

                  Working...