Issue Running an Access Macro through Excel

[joeymonts18]

Good Afternoon,

I am trying to run a Macro through excel without opening the Access DB on my machine. The Access DB is on a shared network drive that everyone in my company uses. The issue is that it is running on my machine but not on anyone elses. This is the code that I am using:
Sub Macro1()
'
' Macro1 Macro
'


Dim A As Object
Set A = CreateObject("Access.Application")
A.OpenCurrentDatabase ("\\DAfile\BSG\Joe\Deep Dive\Updated Forecast\Post Meeting JDA Database.accdb")
A.DoCmd.RunMacro "MACRO"
A.CloseCurrentDatabase
A.Quit
Set A = Nothing
'
End Sub

As I said, it is working on my machine, but not on others who are also connected to this shared drive. The error they are receiving is below (Error 3044). The debugger is pointing towards this line as the issue "A.DoCmd.RunMacro "MACRO"". Please let me know if you have a solution or need any additional information. Thanks!

 

[edmitchell]

Hi

if the 'others' Open the database in Access and run the Macro, what happens, does it work/give an error?

 

[Norie]

What's the error message?

 

[Ammi1989]

Hi,

Check/compare the Access Reference in other user system and if its not same with you the check the reference that is missing in user system