Link/Shortcut to Access dB

[NeedHelp]

I'm trying to create a hyperlink or shortcut in an email to send to
survey respondents. The Access survey database resides on a server and
has 3 "modules"...one module is a survey for Group 1, the next is a
survey for Group 2, and the third is an Administrator Console. So for
example, my developer has set it up for me to gain access to the
database by going to Start > Run, and entering either:

MSACCESS "C:\filepath\filepath\survey.mdb" /cmd "Group1Survey"

MSACCESS "C:\filepath\filepath\survey.mdb" /cmd "Group2Survey"

MSACCESS "C:\filepath\filepath\survey.mdb" /cmd "Admin"

We've got this to open the surveys, but now we need to get it in a link
to the respondents. Again, this can be either a hyperlink or a
shortcut...but needs to have the [/cmd "Group1Survey"] part in
it...this defines what module of the database is opening.

Sorry for my ignorance on this subject...my developer is out of town
and I need to deliver! Thanks in advance.

 

[Douglas J. Steele]

Shortcuts are simply files (with an extension of .LNK), so it'll probably be
simply to mail the shortcut.

Rather than simply "MSACCESS", it should be the full path (including
extension) to MSACCESS.EXE.

If the database is on the server, then "C:\filepath\filepath\survey.mdb"
can't be correct. Remember, Access is going to be running on their client,
not on the server. The reference to the C: drive is their local C: drive.
You'll need something like \\server\share\filepath\survey.mdb (or, if you
can be certain they'll all have the same drive mapping,
"x:\filepath\survey.mdb", where x is the correct drive letter)

 

[Jerry Porter]

Douglas,

I experimented with this and found that Outlook 2002 would not open a
shortcut in an attachment. It required me to save the attached shortcut
to my computer before running it.

I tried creating a hyperlink to a shortcut on my computer of the
format:
file://C:\foldername\myshortcut.lnk
I also tried
file://C:/foldername/myshortcut.lnk

But when I clicked the hyperlink Outlook said it couldn't find the
file.

If this worked, it would require you to have the shortcuts saved on
each user's computer ahead of time.

Jerry

 

[NeedHelp]

Douglas,

You are correct...this is the path I used when I had it on my local
machine. The path I'm using now is \\server/share/filepath/survey.mdb.

I'll try the full path to Access and see if that works...but I have a
bigger problem now. I'm now able to open the database using the Run
function, but it asks for a parameter now...it's looking for my:

/cmd "Group1Survey"

piece of the statement. This is the major piece I'm looking for. I
cannot create a shortcut that has this parameter in it. It opens
Access and asks for a parameter. It's driving me crazy.

Shortcuts are simply files (with an extension of .LNK), so it'll probably be
simply to mail the shortcut.

Rather than simply "MSACCESS", it should be the full path (including
extension) to MSACCESS.EXE.

If the database is on the server, then "C:\filepath\filepath\survey.mdb"
can't be correct. Remember, Access is going to be running on their client,
not on the server. The reference to the C: drive is their local C: drive.
You'll need something like \\server\share\filepath\survey.mdb (or, if you
can be certain they'll all have the same drive mapping,
"x:\filepath\survey.mdb", where x is the correct drive letter)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I'm trying to create a hyperlink or shortcut in an email to send to
survey respondents. The Access survey database resides on a server and
has 3 "modules"...one module is a survey for Group 1, the next is a
survey for Group 2, and the third is an Administrator Console. So for
example, my developer has set it up for me to gain access to the
database by going to Start > Run, and entering either:

MSACCESS "C:\filepath\filepath\survey.mdb" /cmd "Group1Survey"

MSACCESS "C:\filepath\filepath\survey.mdb" /cmd "Group2Survey"

MSACCESS "C:\filepath\filepath\survey.mdb" /cmd "Admin"

We've got this to open the surveys, but now we need to get it in a link
to the respondents. Again, this can be either a hyperlink or a
shortcut...but needs to have the [/cmd "Group1Survey"] part in
it...this defines what module of the database is opening.

Sorry for my ignorance on this subject...my developer is out of town
and I need to deliver! Thanks in advance.

 

[Douglas J. Steele]

Sorry, I don't get to use Outlook at work anymore (we use Notes <yuck>)

I actually was thinking in terms of e-mailing the link and having the user
detach/download/save the file that contains the link. Can't attest that
that's possible in Outlook, but I would assume it should be.

 

[Douglas J. Steele]

Not sure I follow what you mean by "using the Run function". However, you
definitely need to have msaccess.exe in front of the database name: /cmd is
a command-line argument for msaccess.exe, not for an mdb.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Douglas,

You are correct...this is the path I used when I had it on my local
machine. The path I'm using now is \\server/share/filepath/survey.mdb.

I'll try the full path to Access and see if that works...but I have a
bigger problem now. I'm now able to open the database using the Run
function, but it asks for a parameter now...it's looking for my:

/cmd "Group1Survey"

piece of the statement. This is the major piece I'm looking for. I
cannot create a shortcut that has this parameter in it. It opens
Access and asks for a parameter. It's driving me crazy.

Shortcuts are simply files (with an extension of .LNK), so it'll probably
be
simply to mail the shortcut.

Rather than simply "MSACCESS", it should be the full path (including
extension) to MSACCESS.EXE.

If the database is on the server, then "C:\filepath\filepath\survey.mdb"
can't be correct. Remember, Access is going to be running on their
client,
not on the server. The reference to the C: drive is their local C: drive.
You'll need something like \\server\share\filepath\survey.mdb (or, if you
can be certain they'll all have the same drive mapping,
"x:\filepath\survey.mdb", where x is the correct drive letter)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I'm trying to create a hyperlink or shortcut in an email to send to
survey respondents. The Access survey database resides on a server and
has 3 "modules"...one module is a survey for Group 1, the next is a
survey for Group 2, and the third is an Administrator Console. So for
example, my developer has set it up for me to gain access to the
database by going to Start > Run, and entering either:

MSACCESS "C:\filepath\filepath\survey.mdb" /cmd "Group1Survey"

MSACCESS "C:\filepath\filepath\survey.mdb" /cmd "Group2Survey"

MSACCESS "C:\filepath\filepath\survey.mdb" /cmd "Admin"

We've got this to open the surveys, but now we need to get it in a link
to the respondents. Again, this can be either a hyperlink or a
shortcut...but needs to have the [/cmd "Group1Survey"] part in
it...this defines what module of the database is opening.

Sorry for my ignorance on this subject...my developer is out of town
and I need to deliver! Thanks in advance.