Solved Autoexec Macro works on A10 (accde) but not A365 (accde) - Error #2425 (1 Viewer)

[Babycat]

Hi Everyone

I have a Access project (Sampledb.accdb) on my PC win10 - Office365 (64bits)
A virtual machine (on same PC) i have win10 Office10 (Pro-64 bits)

On my PC:
-Run accdb: Working well

On Virtual Machine (win10 Office10):
-Run accdb: Working well
-Save as Office10_db.accde: This file .accde is working well, too

I copy this Office10_db.accde to my PC and try to run it, now I got error #2425 as below screenshot.

The accdb does not have any table, form, query...
Can anyone help to point out the possible cause and a solution?

 

[jdraw]

Your sampledb.accdb and sampledb.accde
work as expected on my
Access 365 Version 2307 - Build 16.0.16626.20134 64-bit

 

[Babycat]

Hi jdraw.

How did you build sampledb.accde?
Did you build it from Access 365 (Version 2307 - Build 16.0.16626.20134 64-bit)? If so, then yes, it should work.
I built it from Access10 and it got error when running on Access 365.

I attached the accde file what built from Access 10 (14.0.4750.1000)
Could you please try to run with your A365?

 

[The_Doc_Man]

Check the references for both files. Look at the detailed version information. I suspect that there will be a minor version mismatch between some library that is on the machines. I can't swear to this, but an ACCDE file might not be able to auto update to the newest library, unlike an ACCDB file that will automatically upgrade if a newer library version is present in the references list. The idea of the DE file is that you aren't supposed to be able to change it. I am GUESSING on this and if someone else says that actually works, then my guess was bad.

 

[CJ_London]

I’ve developed accde’s in 2010 that run in later versions so long as the bitness is the same. So I think the standard access libraries are ok, but perhaps not others such as excel (I always use late binding)

 

[Babycat]

Hi DocMan

The reference list is same for both

 

[Babycat]

I’ve developed accde’s in 2010 that run in later versions so long as the bitness is the same. So I think the standard access libraries are ok, but perhaps not others such as excel (I always use late binding)

Hi CJ_London

Since you are running on A10, could you please do me a favor by making accde file from accdb file on post #1 and upload the file here.
I will download it and run on my A365 to see the result...

Thank you

 

[Josef P.]

Is a 32-bit accde created with A10? Then it will not run in A365 64-bit.

 

[Babycat]

Is a 32-bit accde created with A10? Then it will not run in A365 64-bit.

They are both 64 bits

 

[Josef P.]

Can you create a sample file as accde with A10 and upload it here?

/edit:
Overlooked: #3

 

[Babycat]

Can you create a sample file as accde with A10 and upload it here?

Hi Josef
It is already uploaded in post#3. Can you try to run it with A365?

 

[Josef P.]

It looks like A2016(ff) cannot read the A2010-accde.

No code module is displayed.
I never use Office 2010 in 64-bit mode, maybe these two versions have always been incompatible.

More tests executed in an accdb:

Private Sub Test1()

   Dim app As Access.Application
   Dim ref As Reference
 
   Set app = GetObject(CurrentProject.Path & "\Office10_db.accde")

   Debug.Print "File:", app.CurrentDb.Name
 
   For Each ref In app.References
      Debug.Print ref.Name, ref.IsBroken, ref.FullPath
   Next
   ' => all ok
 
   'app.Run "modAutoExec.User_AutoExecHandler"
   app.Run "User_AutoExecHandler" '=> Error: proc not found

End Sub

Private Sub Test2()
' call as add-in (rename file to Office10_db.accda)
   Application.Run CurrentProject.Path & "\Office10_db.User_AutoExecHandler" '=> Error: proc not found

End Sub

 

[Babycat]

Hi Josef

Thanks for your help. Since your A2016 is also not able to open my A2010 accde file. I have narrowed down the cause,
I suspected the A2010 accde file got problem itself, then I tried to install Office 2010 Pro Plus (The current one is A2010 Pro).
Build accde with Access 2010 Pro Plus and It works.
Now I can run this accde with my A365....

No clue why A2010 Pro does not do it job.

Just shared if any one have same problem.

@Josef: Attached is accde file built with Office 2010 Pro Plus. Feel free to confirm if it also works with your A2016.

 

[Josef P.]

I can start it with A365 2307 (64 bit)
Also my test code from #12 works.

 

[jdraw]

When I run your Office10_db.accde on my A365, I get


and