Access DB Security

[efoote]

I am trying to set up users rights on an Access Database that is
accessed by users over the network from the server. I have set up the
access rights with usernames and passwords but the rights will only
apply on the machine that I set them up on. All other machines can
access the DB with out authenticating and can access everything. We
are using W2K Server. Any
ideas how to make the rights apply over the entire network?

[Rick Brandt]

efoote wrote:

I am trying to set up users rights on an Access Database that is
accessed by users over the network from the server. I have set up the
access rights with usernames and passwords but the rights will only
apply on the machine that I set them up on. All other machines can
access the DB with out authenticating and can access everything. We
are using W2K Server. Any
ideas how to make the rights apply over the entire network?

This is because you didn't apply security properly. If you had only people
using the same workgroup file that you used to secure the file would be able to
open it.

Once you apply security correctly (those other users can't get in at all) then
you can put the MDW file in a shared location and create for each user a
shortcut that specifies the secure MDW file. The structure of the target of
such a shortcut would be...

"Path to MSAccess.exe" "Path to MDB" /wrkgrp "path to MDW"

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com