Workgroup File

[Len via AccessMonster.com]

We have about 50 computers with Access on them all using a secure MDW file
that we creted set up on a network drive. Each copy of Access is set up
using Tools Security Workgroup Administrator and then joined to this secure
MDW file. However, there are about 5-6 people who "lose" this join and go
back to the default MDW file on their Crive. Any reason this might happen?
Thanks - Len

 

[Keith]

We have about 50 computers with Access on them all using a secure MDW file
that we creted set up on a network drive. Each copy of Access is set up
using Tools Security Workgroup Administrator and then joined to this
secure
MDW file. However, there are about 5-6 people who "lose" this join and go
back to the default MDW file on their Crive. Any reason this might
happen?
Thanks - Len

I have no explanation for losing the group to which they're supposed to be
joined but the 'accepted' (tried and tested) method for joining a workgroup
is to do it at runtime using the "/wrkgrp" command line switch. Using this
method your users will always join the correct group at start-up and will
not be joined to it unnecessarily.

Regards,
Keith.
www.keithwilby.com

 

[Len via AccessMonster.com]

I have tried setting up a shortcut on their desktop with the /wrkgrp switch
and get an error message which says that Access cannot find the system.mdw
file on the network drive I have pointed to. I can see the system.mdw file
on the network drive and even open it. Any other thoughts? Thanks again.

 

[Guest]

Len,

I just saw your question and thought I might pick your brain. I'm trying to
set up a User-Level Security for a program I am working on but I cannot seem
to get it to work on the LAN. I can set it up on the computer I am using but
I tried to move the .mdb and secure.mdw files to the required folder on the
LAN but when I go to another computer to access it it states that I do not
have the proper permissions. Any idea what I'm doing wrong and how do I go
about getting this program set up on the LAN?

Thanks,

 

[Joan Wild]

I have tried setting up a shortcut on their desktop with the /wrkgrp
switch and get an error message which says that Access cannot find
the system.mdw file on the network drive I have pointed to. I can see
the system.mdw file on the network drive and even open it. Any other
thoughts? Thanks again.

Does the user have permission to the folder where the mdw is? Have you
included the full path to msaccess.exe in the shortcut?

 

[Joan Wild]

Len,

I just saw your question and thought I might pick your brain. I'm
trying to set up a User-Level Security for a program I am working on
but I cannot seem to get it to work on the LAN. I can set it up on
the computer I am using but I tried to move the .mdb and secure.mdw
files to the required folder on the LAN but when I go to another
computer to access it it states that I do not have the proper
permissions. Any idea what I'm doing wrong and how do I go about
getting this program set up on the LAN?

Just putting them on the server isn't enough. It's working from your
computer, because you are likely joined by default to your secure mdw (use
the workgroup administrator to rejoin the standard system.mdw).

Create and give each user a desktop shortcut that points to the correct mdw
to use. The target would look like:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

You can use UNC pathnames in the above and not worry about drive mappings.

 

[Guest]

So, if I put the .mdb and secure.mdw file on the LAN, I would have to go to
every computer to set up the shortcut and pathway to those two files? I
cannot set up a shortcut in the folder for them to paste onto their desktop?

Jeff

 

[Joan Wild]

So, if I put the .mdb and secure.mdw file on the LAN, I would have to
go to every computer to set up the shortcut and pathway to those two
files? I cannot set up a shortcut in the folder for them to paste
onto their desktop?

If they all have the same path to msaccess.exe and put the frontend in the
same location, then they can all use the same shortcut; so yes, you can
email it to them or tell them to copy it from the folder.

 

[TC]

Why didn't you continue the thread that you started before ("Some users
have to rejoin workgroup daily") - and answer the questions that I
asked you in that thread?

To disappear, then start a new thread, causing everyone to start again,
is not very thoughtful. It is not an effective way, to ensure you get
more help in the future.

HTH,
TC