Trying to open one database from another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try using

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