error 2425 after moving accdb to accde RRS feed

  • Question

  • i have a database with autoexec macro which does only this :


    Public Function sharepointbestanden()

    Dim db As DAO.Database

    Set db = CurrentDb
     Set db = Nothing

    End Function

    this worked fine for a long time, but all of a sudden , if i save the database to accde file, the accde file does not work and gives an error 2425 

     the accdb is still working

    Thursday, May 21, 2020 3:07 PM


All replies

  • On the same machine? 

    -Tom. Microsoft Access MVP

    Thursday, May 21, 2020 3:10 PM
  • yes on the same machine and on other machines.

    i think my trusted locations are ok

    Thursday, May 21, 2020 3:46 PM
  • if i remove the function it works
    Thursday, May 21, 2020 3:47 PM
  • I remember this being a problem in Access 2010 corrected by service pack 1.  You don't say what version of Access you are using but I would make sure that everything is up to date (Windows and Office).


    Thursday, May 21, 2020 4:22 PM
  • access office 365
    Friday, May 22, 2020 7:05 AM
  • very strange,

    i deleted the autoexec and compact and repaired the database

    than i created the autoexec macro again and now it works .

    is there an explanation for that ?

    Friday, May 22, 2020 7:43 AM
  • What is your build number?  Have you tried an Office Repair?  Have you tried updating our reverting your build to see if the issue is build related, therefore a bug?

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

    Friday, May 22, 2020 5:03 PM
  • yes, i did a repair, but that did not help.


    Friday, May 22, 2020 5:55 PM