Hi - I have managed to create a shortcut to an Access database with the /ro switch added to the Target line - now I would like to use Access VBA to follow the shortcut does anyone have any ideas - I have tried using the Shell to open but no joy.
thanks for reply Ax - I had tried various incarnations of this but I think my quote placing is wrong - the path to the .mdb file is held in a string strFullPath keep getting file not found error though can use the same path to create a shortcut. The latest I tried was:
well Ive got a little further forward. I can run the Shell command:
Shell ("C:\Program Files\Microsoft Office\Office11\msaccess.exe /ro")
this starts up an instance of msaccess and accepts the /ro switch.
The problem now is that when I place the path and file name I want to open in front of it - I get an error message stating that I am using an illegal switch - conatins an option that Microsoft Access doesnt recognise ?
Path and file name is "C:\My Documents\Security Gateway\MyDb.mdb"
Anyone got any ideas where I am going wrong ?
Thanks in Advance