Solution
Okay if anyone else needs this info, i found the answer.
In a macro choose the action RunApp then, in the Command Line type in the following code C:\Program Files\Microsoft Office\OFFICE11\MSAccess.exe G:\Database Location\DatabaseName.mdb
What you are trying to do is launch Access then open the database. If your Access executible file is not in this location you will need to change the code.
.
