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...