Run Access Macro/Procedure with VB.net

[M. Wilson]

Hello,

I have an Access 2007 database and I would like to run a procedure that I
have in Access 2007 from VB.net.

I have found one way to do it with the Microsoft.Office.Interop.Access
import, however I wanted to know if anyone had any other suggestions. This
method requires that my database be an Access project (.adp) instead of a
database (.accdb). This is a hinderance for me.

Any suggestions are appreciated.

Sincerely,
M. Wilson

 

[Clive Lumb]

Hello,

I have an Access 2007 database and I would like to run a procedure that I
have in Access 2007 from VB.net.

I have found one way to do it with the Microsoft.Office.Interop.Access
import, however I wanted to know if anyone had any other suggestions.
This
method requires that my database be an Access project (.adp) instead of a
database (.accdb). This is a hinderance for me.

Any suggestions are appreciated.

Sincerely,
M. Wilson

In general what you can do in VBA you can do just as easily in .NET. What
does this macro/procedure do ?