Shortcut on desktop

[sjs]

Is it possible in Access vba to create a shortcut on the desktop which points the mdb containing the vba and an icon in the same directory?

 

[Tim K.]

Check this HOWTO: Use Windows Script Host to Create Shortcut with Parameters out.

 

[sjs]

Tim, thanks for the link. Will check it out when back in office in two weeks.

Presumably I can run this code as is in Access 97 VBA?

Also would I be able to adapt this code to point to my own icon

 

[Tim K.]

Yes. Check this Create Shortcut as well.

 

[sjs]

Thanks, these two links helped me resolve the problem

 

[doulostheou]

I cannot access the second link, but the part that is really confusing me is that when I run the code from the first link, everything appears to run fine but no shortcut actually appears on the desktop. Any thoughts?