I am trying to run a macro in another database from the database I'm currently in. The code I'm using is below. When I run this code, I get an error 7866 (db opened exclusively or doesn't exist). I've checked multiple times to make sure the db exists and also to check that no one is in the db when this code runs. There is no ldb when I run the code but I consistently get this error. I can manually go into the other database and run the macro with no problem.
Set acApp = CreateObject("Access.Application")
.Visible = False ' Just not show it.
.DoCmd.RunMacro strMacroName, 1, 1
Set acApp = Nothing