Linking Databases

[Amanda.Perez.09]

Hi All,

I'm trying to create a Main Switchboard that opens 5 other databases,
depending on selection. Can I do this using a macro or should I be
doing something else?

Thanks,
Amanda

 

[Steve Schapel]

Amanda,

You can do this using a RunApp action in your macro.

 

[Amanda.Perez.09]

Steve,

Thank you for that information. I did that and now I'm having trouble
with the command line. In the command line I have the path that the
data base is in and the following message pops up:

"Microsoft Office Access can't invoke the application using the RunApp
action"

Thank you,

Amanda

 

[Steve Schapel]

Amanda,

It's difficult to know without seeing the exact Command Line you
entered. But I think it should be something like this:
"C:\Program Files\<Path to Access>\Msaccess.exe" "C:\YourFolder\YourDB.mdb"