Greinerjr
asked on
In VB6 and ACCESS how do I run ACCESS Macros and queries using VB code (I use recordset, etc)
I program in VB 6 using ACCESS by using recordset commands (movefirst, movelast, Addnew, etc.). I now need to be able to execute macros and queries withing the database using VB code. With Currendb set to the table I need to be able to run the Macros and queries. I know how to convert a macro into a vb function and insert it into a VB program, how ever it dos not work. What references and components must I have installed. I have Microsoft Access 11.0 Object Library on. as well as DAO 3.6.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can use Access/Jet for the data store.
Then you decide what you are building your app with - Access or VB.
If you are using VB then you don't want any part of the app in Access otherwise you have to install a copy of Access on each machine that runs your app as well as having to deal with the automation of Access objects.
VB apps are a lot easier to distribute than Access apps and there are is lots more functionality but you don't have the rapid development for database related features.
If you are installing Access anyway then you can develop the whole app in Access and it is likely to be a lot quicker to develop because of the easier forms and report creation.
At the moment you seem to have the worst of both worlds instead of the best of them.