Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 715
  • Last Modified:

Run Access Macro from Excel

I am trying to run a Access Macro from Excel using the following. I'm getting a run-time error 7866.
"Microsoft Office Access can't open database because its missing, or opened exclusively by another user, or is not an ADP file.

Private Sub CommandButton4_Click()
  ' Initialize string to database path.
    Const strConPathToSamples = "C:\Users\szyynr\Documents\Allocation_Constraint_Database_.accdb"

    strDB = strConPathToSamples & "test.mdb"
    ' Create new instance of Microsoft Access.
    Set appAccess = _
    ' Open database in Microsoft Access window.
    appAccess.OpenCurrentDatabase strConPathToSamples
    ' Run Access macro.
    appAccess.DoCmd.RunMacro "mac_Download GMNA Final Constraint Report", 1

End Sub

Open in new window

  • 3
1 Solution
What line exactly does it crash on?

When you run the macro do you have the Access Database open in the background??
At the end of your macro make sure you close Access and set the variable to nothing

Set appAccess = Nothing

Open in new window

mato01Author Commented:
No, I do not have Access open in the background.  And that is at the bottom.

objAccess.OpenCurrentDatabase (strDbName) ----- This is where the error is occuring.
'to run a macro
objAccess.DoCmd.RunMacro strMacro

Set objAccess = Nothing
End Sub
mato01Author Commented:
Hi Experts,

Need further asssitance to run a access macro from excel.
mato01Author Commented:
I will accept this answer because it was the relevant to the solution.  Thanks

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now