Run a MS Access Subroutine from VB.Net

[Guest]

I want to execute a subroutine in MS Access database. But I get an error that
"Microsoft Access can't find the procedure 'myModule.mySub.' "

Dim acApp As Microsoft.Office.Interop.Access.Application
acApp = CreateObject("Access.Application")
acApp.Application.Visible = True
acApp.OpenCurrentDatabase("C:\myDirectory\myDB.mdb", True)
acApp.Application.Run("myModule.mySub")

mySub is defined as a Public sub.

Suggestions?

 

[Paul Clement]

¤ I want to execute a subroutine in MS Access database. But I get an error that
¤ "Microsoft Access can't find the procedure 'myModule.mySub.' "
¤
¤ Dim acApp As Microsoft.Office.Interop.Access.Application
¤ acApp = CreateObject("Access.Application")
¤ acApp.Application.Visible = True
¤ acApp.OpenCurrentDatabase("C:\myDirectory\myDB.mdb", True)
¤ acApp.Application.Run("myModule.mySub")
¤
¤ mySub is defined as a Public sub.

I don't believe that you specify the module name.


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Guest]

Unfortunately, it still bugged out on me after I got rid of the module name.

Thanks for the idea. Do you have any others?

Mark

 

[Paul Clement]

¤ Unfortunately, it still bugged out on me after I got rid of the module name.
¤
¤ Thanks for the idea. Do you have any others?
¤

I don't see any problems with the syntax. Have you tried doing a Debug...Compile from the Microsoft
Access code editor?


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Guest]

Paul - Thanks for the comments.

And the problem was:
The module name and the procedure name were the same!!!
Once the procedures name was changed, the code
' acApp.run "newSubname" ' worked great.

Only lost a half a day on it!

Mark