none
Database Crash RRS feed

  • Question

  • Hello,

    I have a Database that works through access 2003 Runtime, and recently this crashes from the moment a photo is loaded.

    If you put the code below in comment, the database works.

    foto = ArticlePhotoExists(ProduktNr)

        If IsNull(foto) Then

          Image1.Visible = False

          CmdToClip.Visible = False

          CmdToMail.Visible = False

        Else

          Image1.Picture = foto

          Image1.Visible = True

          CmdToClip.Visible = True

          CmdToMail.Visible = True

        End If

    Before the front-end worked well and with other users it  works perfectly.

    I have a Win10 PC with Office 365 and Adobe Suite.

    A colleague also has the adobe suite but runs on Win7.

    Below are the things i tried to fix the problem

    • Reinstalled Office365 and Access Runtime
    • installed converter Pack
    • SFC /scannow
    • Windows Updates

    I don't know what else i can try, so I hope someone here can help me?

    Thanks in Advance!

    Gin

    Monday, February 26, 2018 11:35 AM

All replies

  • By 'Crashes', do you mean you get Access's White Screen of Death with a message similar to "MS Access has stopped working...", with the database abnormally quitting? Or do you mean that the code produces an error (which one, and which line of code?) that you are able to recover from without restarting the database?

    Miriam Bizup Access MVP

    Monday, February 26, 2018 11:51 AM
  • It is very hard for any of us to help when only shown an excerpt of your code in this manner. We'd need to see the complete procedure and other procedure it refers to.  A sample DB is often best.

     

    Do you have error handling in all your procedures?  This is critical in runtime applications.

     

    Does your VBA code compile without errors?
    Have you validated the VBA References?

     

    Also, are you saying you're developing in Office 365, but your users are running runtime 2003?  That's a BIG no-no!  You always have to develop using the oldest version being used to run the DB, so in this case you need to develop using 2003 or upgrade your users" runtime to 2016.


    Daniel Pineault, 2010-2017 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net



    Monday, February 26, 2018 12:21 PM