Triggering an Access macro from within a Visual Basic - exe
Posted on 2001-06-14
I have the following situation :
An Access database residing on a server.
The same Visual Basic Exe is installed on several client PC's , the exe reading the data from the Access database.
Now i want to make a button on my VB-exe form to launch a macro , defined in the Access Database.
I tried it using the Shell command , but since i don't have Access installed on the client PC's ( only on the server ) , it gives an error.
Is there a way to do it using OLE-automation ? The Database object doesn't contain a method to launch macro's , only to execute Queries.