Execute an access DB macro from VB.NET

Hot Topic

Vb in acces : hide input data
getting web pages from VBA?
how to read merged cells?
Problems with BSM
Absolute Links in Excel
Put E-mail In From Field
Why Excel 2003 keeps PivotItems with zero record count after refresh?
MS Word Option Button Collection
Calling procedure upon deactivate
Important MS Partner Question

Microsoft ISV

Source Object as a query
macro doesn't run on open
Excel, Forms, and Charts
XSL applied with VBA
VBA Syntax
Best way to learn VBA for Excel
Help Event
SQL Server 2005 Resourse Kit exception
Application Error
Microsoft Platform Test for ISV Solutions & FxCop

Execute an access DB macro from VB.NET

Hi,

I am having problems trying to execute an access DB macro from my VB.NET APP. Any help is welcome.

Thanks Mike

Answer this question

Execute an access DB macro from VB.NET

  • jchmack12

    Hi,
    Thanks for the code. I have it working now. The only part that I could not get to work was the "CloseCurrentDatabase"; however, the quite command worked great.

    Thanks Again Mike

  • Ole Gulbrandsen

    Mike,

    One way this can be done is to include the reference to Microsoft Access object library in COM, and the use the OpenCurrentDatabase.  You can keep it hidden in the background, however if there is an autoexec macro or a startup form then this will cause the application to be displayed.

    Here is a code sample on how to achieve this



    Dim Adb As New Access.Application
    Adb.OpenCurrentDatabase("Path To the database")
    Adb.Run("procedure name to be ran..")
    Adb.CloseCurrentDatabase()
    Adb.Quit()

     
  • Execute an access DB macro from VB.NET
Answer this question