Access shortcuts/icons

  • Thread starter Thread starter LC
  • Start date Start date
L

LC

Hi,
I was wondering if I create an shortcut/icon for the
access database, would the shortcut still work in MS
Outlook as an attachment? Such that I would email all
users the shortcut rather than letting them access it in
a shared folder... How would I make it point to a shared
folder as an attachment of an outlook email?

Thanks in advance
LC
 
Hi LC,

In principle this works provided the path to the database is the same on
all the computers; so it's usually best to point the shortcut to a UNC
path (e.g. \\SERVER\SHARE\Folder\Subfolder\File.mdb) and not a mapped
drive.

In practice,
(a) Outlook (in recent versions) tends to block attachments that it
considers security risks, including all shortcuts.
(b) For best results, multi-user Access databases should be "split" with
the data in one "back end" mdb file in a shared folder, and the "front
end" of forms, queries, reports, etc. in a separate mdb file. A copy of
the front end should be installed on every workstation. In this
situation, there's no need for a shortcut to the shared folder.
 
Hi BerHav,

Thanks for you help. I wish at the moment I can do trial
and error. Unfortunately, I am a newbie at this whole
access database issue.

Yes I would like the users to start the access from an
outlook email. The hyperlink idea is very good.
However, being a newbie I dont know how to do that. I
asked around and no one is available to help me with
that. So I was wondering if you can please guide me
through this.

Thank so much
LC
-----Original Message-----
Hi,

Why don't you just use the usual way : Trial and error?? ;-)

Nevertheless, shortcuts can be used by everyone without
Click to expand...
amending as long as they have mapped the drive and path
the same way like you or setup in the shortcut.
I would suggest that the users detach the shortcut and place it on their desktop.

We use Lotus Notes as E-mail program and there it's not
Click to expand...
possible to start the shortcut, don't know Outlook that
much as i don't use it all.
If you want them to start the access db out of outlook,
Click to expand...
why not sending a hyperlink of the db?
 
Hi John,

Thanks for your idea. However, my boss want users to
have access to the database without going to every
computer and mapping the shared drive nor installing any
shortcuts for the user. He wants this process to be time
efficient since there will be hundreds of users.

Do you have any other ideas to have the user access the
application without installing nor mapping drives?

Do you know anything about how hyperlinks works in which
the hyperlink will be pointing to the application?

Thanks so much,
LC
-----Original Message-----
Hi LC,

In principle this works provided the path to the database is the same on
all the computers; so it's usually best to point the shortcut to a UNC
path (e.g. \\SERVER\SHARE\Folder\Subfolder\File.mdb) and not a mapped
drive.

In practice,
(a) Outlook (in recent versions) tends to block attachments that it
considers security risks, including all shortcuts.
(b) For best results, multi-user Access databases should be "split" with
the data in one "back end" mdb file in a shared folder, and the "front
end" of forms, queries, reports, etc. in a separate mdb file. A copy of
the front end should be installed on every workstation. In this
situation, there's no need for a shortcut to the shared folder.
Hi,
I was wondering if I create an shortcut/icon for the
access database, would the shortcut still work in MS
Outlook as an attachment? Such that I would email all
users the shortcut rather than letting them access it in
a shared folder... How would I make it point to a shared
folder as an attachment of an outlook email?

Thanks in advance
LC
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
Click to expand...
 
LC said:
Thanks for your idea. However, my boss want users to
have access to the database without going to every
computer and mapping the shared drive nor installing any
shortcuts for the user. He wants this process to be time
efficient since there will be hundreds of users.
Click to expand...

But by using the UNC name there is no mapping of a shared drive letter
required.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
LC said:
I was wondering if I create an shortcut/icon for the
access database, would the shortcut still work in MS
Outlook as an attachment? Such that I would email all
users the shortcut rather than letting them access it in
a shared folder... How would I make it point to a shared
folder as an attachment of an outlook email?
Click to expand...

Here's the problem. John mentioned a split setup where each user
gets their own copy of the FE. This is virtually a requirement.

But there is no easy way other than the Auto FE Updater utility to
easily distribute the FE to your many users. With the Auto FE
Updater you create a shortcut pointing to the StartMDB with the
appropriate configuration file. Once that is working you then take
the contents of the target and email that to your users.

I specifically created the Auto FE Updater utility so that I could
make changes to the FE MDE as often as I wanted and be quite confident
that the next time someone went to run the app that it would pull in
the latest version. For more info on the errors or the Auto FE
Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

Note that I'm working on a new release which should be out in a few
days which will create the shortcuts and such. The utility will be
much easier to use.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top