How do I place an icon each user's desktop for the database?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mary A Perez - 20 Mar 2006 20:41 GMT

After setting security & splitting the database, I need to place an icon on
each user's desktop so they may just click & view the database.
How do I do this?

Reply to this Message

sigava77 - 24 Mar 2006 15:05 GMT

Create a batch file and place the following line in it
"path of msaccess.exe" "path of your front end" /wrkgrp "path of your *.mdw
file"
Carla

>After setting security & splitting the database, I need to place an icon on
>each user's desktop so they may just click & view the database.
>How do I do this?

Reply to this Message

Douglas J. Steele - 24 Mar 2006 18:11 GMT

An shortcut is just a file (it has an extension of .lnk, although the
extension doesn't show in Windows Explorer). Assuming everyone has
msaccess.exe stored in the same place, you can simply copy that file.

Alternatively, I show a way to automate the process in my May, 2004 "Access
Answers" column in Pinnacle Publication's "Smart Access". You can download
the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> After setting security & splitting the database, I need to place an icon
> on
> each user's desktop so they may just click & view the database.
> How do I do this?

Reply to this Message