error 2425 after moving accdb to accde

Question

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

  

Public Function sharepointbestanden()

Dim db As DAO.Database

Set db = CurrentDb
 db.TableDefs("Documents").RefreshLink
 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

Answer 1

On the same machine? 

---

-Tom. Microsoft Access MVP

Answer 2

yes on the same machine and on other machines.

i think my trusted locations are ok

Answer 3

if i remove the function it works

Answer 4

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).

-Bruce

Answer 5

access office 365

Answer 6

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 ?

Answer 7

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

Answer 8

yes, i did a repair, but that did not help.