How to programatically call a macro in a different (ie. external) Access database using VBA?

I want to use Access Database1 to call a macro in Access Database2.

The link below describes how to call an external macro in a visio program, but the syntax seems to be a little different with Access.

How can I call a VBA macro that is defined in a different file?

Basically, I want to do something like this (from within database 1)

AccessDatabase=pathToOtherDatabase.mdb

AccessDatabase.runMacroA

Does anybody know how to do this?

Answers


You could use the built in Shell command to call your secondary database, and pass it the macro name in the command line switch, this would force your secondary database to execute the desired macro on open. More about Access command line switches can be found here:

http://support.microsoft.com/kb/209207


Need Your Help

How do i pass an UIImageView between view controllers?

ios objective-c ios7 uiimageview uiimagepickercontroller

I'm trying to choose an image from the camera roll in a view controller and then pass it/show that image in another view controller. Why doesn't the image view get passed?

play a sound using javascript

javascript html audio

I am trying to play a sound on event using javascript

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.