Trying to open one database from another

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?
 
G

Guest

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

Close one mdb open another 2
Excel Changing amounts from one sheet to another using specific item # 7
Starting a database from a Windows Script 2
VBScript to run MS Access form as admin 1
database will not open 1
Open one database from another 4
Copy data from one databse tabel to other database table 1
Open Another Database in Read Only Mode 2

Top