Opening another database probs.

[Zedbiker]

I want to be able to open other databases used by the company from the front
end of the database I have created. I have done it for 3 of the 4 databases
but the last one has a space in its name i.e. Contact Numbers.mdb.

When I try to run it I get an error message saying : " The command line you
used to start Microsoft Access contains an option that Microsoft Access
doesn't recognise" I have tried putting an underscore in (_) but that doesn't
work either.

Here is the code I use :
stAppName = "msaccess.exe \\server\databases\Contact Numbers.mdb"
Call Shell(stAppName, 1)

Is there a way around this problem?

Many thanks in advance for any suggestions.

 

[Douglas J. Steele]

You need quotes around the path:

stAppName = "msaccess.exe ""\\server\databases\Contact Numbers.mdb"""

 

[Zedbiker]

Tried your suggestion but it didn't run Access just came up with:
Error : File not found .

I have tried the following

stAppName = "msaccess.exe ""\\server\databases\Contact Numbers.mdb"""
stAppName = "msaccess.exe "\\server\databases\Contact Numbers.mdb""

without success.

Thanks
???

 

[Ofer Cohen]

Try

stAppName = "\\server\databases\Contact Numbers.mdb"
Application.FollowHyperLink stAppName

 

[Ofer Cohen]

Try

stAppName = "\\server\databases\Contact Numbers.mdb"
Application.FollowHyperLink stAppName

Or try
stAppName = "msaccess.exe """ & "\\server\databases\Contact Numbers.mdb" &
""""
Call Shell(stAppName,1)

 

[Zedbiker]

That did it many thanks!!

Try

stAppName = "\\server\databases\Contact Numbers.mdb"
Application.FollowHyperLink stAppName

 

[Alex Dybenko]

Try to provide the full path to msaccess.exe also

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Zedbiker]

The second method worked better. Many thanks again!!!!