Trying to open one database from another

J

JoeA2006

I am trying to open a database from another database using this code

Call Shell("MSACCESS.EXE ......."

The path of the file I want to open is My Data\Inventory Reporting\Inventory
Report s.mdb
What is the correct path for the My Data folder. Its a backed up folder. I
think it may mirror the My Documents folder on C:\ but Access cant find the
file either way.

Also can spaces be used in the names of the folders for Access to find them?
 
O

Ofer Cohen

Try using

Dim FileNameAndLocation As String
FileNameAndLocation = "c:\DBName.mdb"
Application.FollowHyperlink FileNameAndLocation
 
Top