how to run access macro from VB (DAO or ADO)? 2

[Dan01]

Is there a DoCmd equivalent in DAO or ADO that allows me to run macros or queries from a VB program? Thanks, Dan.

 

[BlackKnight]

Hi,

I don't know about macros but you can execute SQL statements like queries. DAO has the Querydefs collection to allow the use of queries in an Access DB. ADO, which is better, can execute the equivalent SQL statewments.

dim conn as connection
dim rs as recordset
dim strConnect as string

strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=[Source];Persist Security Info=False"

strConnect = Replace(strConnect, "[Source]", "C:\db1.mdb

Conn.Open (strConnect)
rs.open "SELECT * FROM Table1", conn
set conn = nothing: set rs = nothing

Have a good one!
BK

 

[Dan01]

Thanks BK for the example. Will ADO also allow many query types such as UPDATE queries? Dan.

 

[mikemcginty]

Dan

I just went through the process of trying to run a function in an Access module from VB using ADO. Unfortunately it looks like it can't be done. Queries are ok though.

Mike When you call out for help in the darkness, and you hear a voice in return, you're probably just talking to yourself again!

 

[johnwm]

Yes any standard SQL query will run via ADO Let me know if this helps

Check out FAQ222-2244
'There are 10 kinds of people in the world: those who understand binary, and those who don't.'

 

[CCLINT]

To run an Access Macro with-in a VB program you will need to add a reference to the Microsoft Access Object library, or just create the object.
Once done, you can use an object variable on it and then execute the DoCmd method with-in VB.
While this works fine, you may not distribute the Access object with-out the proper license (wouldn't work anyways if ACCESS was not on the client pc).
You may however reference the object with-in your project, and, if the client PC has a copy of ACCESS on it, then there is no problem....if not, then you will not be able to do what you want.

 

[Dan01]

Thanks guys. You all posted good stuff. I created an object and then used obj.DoCmd to run the macro. Dan.

 

[Dan01]

Thanks guys. You all posted good stuff. I created an object and then used obj.DoCmd to run the macro. Dan.