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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Folder 1
Problem with database path (Folder Name contains a Space) 11
Starting a database from a Windows Script 2
Close one mdb open another 2
VBScript to run MS Access form as admin 1
Excel Changing amounts from one sheet to another using specific item # 7
database will not open 1
How to convert OST to PDF? Simple Methods 2

Back
Top