Using the Shell command

[Paul H]

After giving up on the Follow Hyperlink method (too many warnings) to open on database from another I employed Shell successfully.

Shell "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE C:\FIMS_NEW\Databases\FIMS_Reports.accde", vbMaximizedFocus

Will I have to update this path on each upgrade of Access?

[pbaldy]

If memory serves, you can just specify the exe name without the path. Try that and see if it works:

Shell "MSACCESS.EXE C:\FIMS_NEW\Databases\FIMS_Reports.accde", vbMaximizedFocus

[Paul H]

Thanks, will do after lunch.

[pbaldy]

No problem Paul, we Paul's have to stick together.

I tested by the way, and it worked.

[Paul H]

Thanks Paul