workgroup file on a thumbdrive?

[Rick B]

Hello:

I recently copied my personal files to a thumbdrive. When I try to create a
shortcut with the workgroup in it, I get the "you don't have the necessary
permissions..." error. If I use the workgroup administrator and join that
workgroup, then I am fine.

Did I build my shortcut wrong?

Target: "E:\Documents\Secured Accomplishment Tracking.mdb" /wrkgrp
"E:\RickSecure.mdw"
Start in: E:\Documents

Thanks!

 

[Rick B]

Joseph, Thanks for the idea.

I can actually do it when I am joined to the workgroup (on the thumbdrive),
so I know I have all the permissions I need. I can see the locking file
created on that thumbdrive when I do open the file while joined to the
secured workgroup. I am able to do all my normal functions that way.

The only time I have the problem is if I join my default workgroup and try
to use the shortcut. I just assumed my shortcut might be wrong. Since the
preferred way to access a secured file is through a workgroup-specific
shortcut, I wanted to try to set it up.

 

[Albert D. Kallal]

When you use parameters in ms-access, you have to use the full path name to
msaccess.exe, and THE PARAMETERS set what file, and what workgroup file.

You don't mention what version of ms-access, but the shortcut for a2003 will
look like:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"C:\Program Files\Stampede\RidesXP.mde"
/wrkGroup "c:\Program Files\Rides.wrk"

Note that above would be all on one line (seperate each of the above by a
space).
Yours thus should look like

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"E:\Documents\Secured Accomplishment Tracking.mdb"
/wrkgrp "E:\RickSecure.mdw"

So, the shortcut must point to msaccess.exe, and it is the parameters that
you change. the shortcut cannot point to the file...but only ms-access.exe
if you need parameters (if you don't need any parameters such as setting the
workgroup, then you *can* use a shortcut as you have)

 

[Rick B]

lol. And back to my original post. I did create the shortcut. But, it
does not appear to work. When I use the shortcut, it still seems to use my
default workgroup. Instead of asking for my UserID and password, it issues
the error. Thus, my original question- is my shortcut correct? If so, what
could cause the default workgroup to be used when this shortcut is
double-clicked:

Target: "E:\Documents\Secured Accomplishment Tracking.mdb" /wrkgrp
"E:\RickSecure.mdw"
Start in: E:\Documents

 

[Rick B]

Albert:

Thanks!!! That did it. I had the file, the switch, and the workgroup, but
I did not include the application location as the first part of the
shortcut. Once I added that it worked!

Thanks!

 

[Rick B]

Joseph:

I got it. Albert's post reminded me that I had left out the application
path. Thanks for your help as well.

 

[Brendan Reynolds]

Hi Rick,

I don't have a secured MDB available with which to test this, so I could be
wrong, but I think you may need to specify the path to MSACCESS.EXE ...

"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE"
"E:\Documents\Secured Accomplishment Tracking.mdb" /wrkgrp
"E:\RickSecure.mdw"

 

[Rick B]

Brendan:

Thanks. The first line was the key. I did not include the actual
application path.

Thanks!

 

[Tony Toews]

I don't have a secured MDB available with which to test this, so I could be
wrong, but I think you may need to specify the path to MSACCESS.EXE ...

Correct. When passing any kind of a parameter to msaccess.exe you
must also specify the path and name of the executable. Note that this
is a Windows limitation and nothing to do with Access.

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