Hello everyone,

What I am attempting to do is to run a macro on a database that I
created. I can run this just fine since I have the full MS Access
version on my PC, but when I go to others machines that have the
runtime versions, they cannot run it. I get a ActiveX object error. I
have the Access Object Libaray(sp) checked in my References.

Has anyone ran into the problem before, and if so, what was your
workaround?

Sub TestMacro()
Dim appAccess As New Access.Application

appAccess.OpenCurrentDatabase "C:\myDB.mdb"
appAccess.DoCmd.RunMacro "macDoFirst"
appAccess.CloseCurrentDatabase
Set appAccess = Nothing

End Sub

Did you post this in the Access NG also? They would probably have more
knowledge of the problem.

"EAB1977" wrote:

Hello everyone,

What I am attempting to do is to run a macro on a database that I
created. I can run this just fine since I have the full MS Access
version on my PC, but when I go to others machines that have the
runtime versions, they cannot run it. I get a ActiveX object error. I
have the Access Object Libaray(sp) checked in my References.

Has anyone ran into the problem before, and if so, what was your
workaround?

Sub TestMacro()
Dim appAccess As New Access.Application

appAccess.OpenCurrentDatabase "C:\myDB.mdb"
appAccess.DoCmd.RunMacro "macDoFirst"
appAccess.CloseCurrentDatabase
Set appAccess = Nothing

End Sub

Download the MDAC files so that you can install it for them.
http://www.microsoft.com/downloads/d...DisplayLang=en