asked on

Creating an Access Shortcut

I have an Access Database that I want to put on web page as a link. The problem I have right now is that it only work on some computers but not all the computers. The problem seems to be having problem finding the Access executable file because some Microsoft Office files installed on different folders. How can I dynamically determine the ASAccess.exe file location?

Here is the Target location
"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "\\hostname\MobilityDatabase\MobilityDatabase\MXG Readiness.mdb"/wrkgrp "\\hostname\MobilityDatabase\MobilityDatabase\Security.mdw"

the start in

\\hostname\MobilityDatabase

The problem is that some computer might have MSACCESS.exe install on different location. Any help or suggestions will be good!

jasonduan

You don't have to specify the path of MSACCESS since .mdb file should have been already registered with it MSACCESS.EXE on client's computer.

Try the following to see if it works.

"\\hostname\MobilityDatabase\MobilityDatabase\MXG Readiness.mdb"/wrkgrp "\\hostname\MobilityDatabase\MobilityDatabase\Security.mdw"

ASKER CERTIFIED SOLUTION

60MXG

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jasonduan

can you be more specific about the "issue"?

60MXG

ASKER

I put the html code on the web page on the web page and then some users click on the link and their computers froze can not open Access Database.

60MXG

ASKER

here is the html code

NavigateUrl="\\hostname\MobilityDatabase\MobilityDatabase\Mobility.lnk"

60MXG

ASKER

The problems is that all the users with Vista running are not be able to open lnk file and those older computers with XP are okay to open this lnk file. Something has to do with the security just not sure what needed to be change!

60MXG

ASKER

Found the solution! change the url and move the lnk file to local webser and change code to
/mywebroot/mobility/Mobility.lnk on the html code and the file open right up. The lnk file have all the setting like this
"\\hostname\MobilityDatabase\MobilityDatabase\MXG Readiness.mdb"/wrkgrp "\\hostname\MobilityDatabase\MobilityDatabase\Security.mdw"

Thanks jasonduan! Points will be awarded to you tomorrow after it autoclose.

jasonduan

You are welcome. Glad you figured it out.

60MXG

ASKER

solve part of the problems.