Opening another Access Database file with VBA

[VWP1]

I am in one of my Access database files, and wish to use a command button to
open another database file. How is this done?

 

[Tom van Stiphout]

On Sat, 9 Jan 2010 21:00:01 -0800, VWP1

There are several ways. Perhaps the simplest is using the Shell
function. Check the help file.

-Tom.
Microsoft Access MVP

 

[fredg]

I am in one of my Access database files, and wish to use a command button to
open another database file. How is this done?

Here is one method:
Application.FollowHyperlink "c:\PathToDatabaseFolder\MyDatabase.mdb"