WLLadmin
asked on
Can i run existing vba macro with DAO when client does not have MS access?
Our company is poised to purchase a few new laptops. In the interest of saving a few dollars on software, I would like to know if i could get away with downgrading from Office Pro to Office Business Suite on each laptop. The problem is that i don't know whether i can run word and excel VBAs which query an access database using machines that don't have MS Access.
Putting it another way: Is it possible to successfully run a word vba on a machine that has office business suite (which does not come with MS Access) and use the DAO to connect to and pull info from an existing access database?
I'd appreciate some input...thanks!
:)
Putting it another way: Is it possible to successfully run a word vba on a machine that has office business suite (which does not come with MS Access) and use the DAO to connect to and pull info from an existing access database?
I'd appreciate some input...thanks!
:)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Why don't you just download office business suite (without access) trial or evaluation copy and just try it out with that since you gonna buy that...see if it works.
ASKER
Thanks! I checked it out on a machine that doesnt have Access....so glad it works! :)
ASKER
Thanks again!
ASKER
It would be a rather large problem if it doesn't work - That being said: Is it worth the hassle of uninstalling access form a client machine and then trying it out...?