ms access - Can't create shortcut to .ACCDE file -
i have created access 2013 db need deploy several machines, of don't have access installed on them. can create .accde file .accdb file. when create shortcut .accde file using vbscript, shortcut insists on setting "opens with" field "ms access". since .accde file executable file, need open directly, not open using access. how can vbscript set this? here's using far.
set objfilesys= createobject("scripting.filesystemobject") set ows = wscript.createobject("wscript.shell") if objfilesys.fileexists(ows.specialfolders("desktop") + "\clientdata.lnk") wscript.quit end if set olink = ows.createshortcut(ows.specialfolders("desktop") + "\clientdata.lnk") olink.targetpath = "c:\client data\unityclients.accde" olink.description = "client data" olink.workingdirectory = "c:\client data" olink.windowstyle = 3 olink.iconlocation = "c:\client data\ufslogo.ico" rem olink.openswith = "" olink.save
i tried setting "openwith" property, that's not valid. :-(
i think accde files run on machines without full blown access still need access run time...https://www.microsoft.com/en-us/download/details.aspx?id=39358
Comments
Post a Comment