I have a shortcut on my desktop which runs an Access db, and ties in the security.
The 'Target' box is this :-
"C:Program FilesMicrosoft Office <font color=blue>Office10</font color=blue> MSACCESS.EXE" "C:Program FilesDL.mdb" /wrkgrp "Socument Librarysystem.mdw" /user /pwd
now, one of things i have created is a batch file, to run every time the pc runs, to copy over the most recent version from the server, to the local machine.
The problem comes when the machine is upgraded to windows xp. because the the link is no longer valid, the bit highlighted on an xp machine is now Office11
My first idea, was to make 2 different shortcuts and then test for the directory in the batch file, and copy over the appropriate shortcut.... BUT,
on a win2000 machine, when you change the target on a shortcut, as above, it won't let you do it, because the path isn't valid.
So, i need a way to launch Msaccess.exe, from a shortcut on either a win2000 machine, or a winxp machine.
the only thing i can think of, is to copy the whole msaccess.exe program to another folder in the batch file. but that seems a bit drastic, and im not sure what other effects it may have.
Here is the batch file as is:-
<font color=red>copy "Socument LibraryDOCDL.mdb" "C:Program FilesDL.mdb"
IF EXIST C:Program FilesMicrosoft OfficeOffice11 Goto winxp
'----------------- win2000 version here ------------------------
copy "Socument LibraryDOCDL.lnk" "Cocuments and Settings%Username%Desktop"
'copy "Socument LibraryDOCDL.lnk" "Cocuments and Settings%Username%Desktop" /Y /I /E /H