Opendatabase command

[Raj]

I am trying to create a Macro that will open another database but not sure
what to put in the command line. I tried to put the path where the database
it located but i get and error.. Hope someone can help..
Thanks

 

[Guest]

Call Shell("yourfilepath", 1)
what error did you get?

 

[Jim/Chris]

Action: RunApp

Command Line: "Application location" "file location"

example
"c:\program files\microsoft office\office\msaccess.exe"
"c:\my documents\test1.mdb"

"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\YourFile.mde"

Jim

 

[Raj]

the message is get is
"The text you entered isn't an item in the list"
I am really not understand what I am suppose to do once i chose
"OpenDatabase" from the option list. Do I add the statemnet you provied
after the OpenDatabase? This is where the confussion is coming from. I am
think once i choose the OpenDatabase Option it should give me a place to put
the path. I am incorrect in my thinking.

 

[Raj]

Jim/Chris,
Thank you..
I hope you can clear up some confusion for me… So it not possible to use the
OpenDatabase? The same way? What would you this option for?

Action: Runcommand
Command Line: OpenDatabase
???(No place to put the path)

Thank you, Raj

 

[Guest]

you said you wanted a macro. i assumed that your were
using the runapp which is what opens other applications
such as excel, word and acess.
the runapp has only 1 part. the path.
Macro tab>new macro>scroll to runapp>paste path