I've found code that should make it possible to run a macro inside an access database from VB.NET.
Dim Adb As New Access.Application
Adb.OpenCurrentDatabase("Path To the database")
Adb.Run("procedure name to be ran..")
Is it possible to trigger an event that would make it evident that the macro has finished running?
I looked here http://msdn.microsoft.com/en-us/library/office/ee291795(v=office.12).aspx
but didn't see anything that looked like it would work.
I don't want the user to continue until the process has finished.
Thanks for your help!