I have created an Access database which is distributed onto a Network.
Currently I have created all the users which can be accessed only from my PC,
but the security permissions and passwords don't work when the users access
the database. I have attempted to "join" the users to the secured.mdw file
but it appears to be pointing at their default system.mdw file. Does anyone
know how I can make the users point at the secured.mdw?

Craig C wrote:
> I have created an Access database which is distributed onto a Network.
> Currently I have created all the users which can be accessed only
> from my PC, but the security permissions and passwords don't work
> when the users access the database.

When you say 'don't work' do you mean they can't access the database? If
so, that's good, they shouldn't be able to unless they use the correct
workgroup file.

> I have attempted to "join" the
> users to the secured.mdw file but it appears to be pointing at their
> default system.mdw file.

Why do you think it's pointing to their default system.mdw file after
joining them? Anyway, it doesn't matter; you shouldn't change their default
workgroup file as that will impact all databases they use.

> Does anyone know how I can make the users
> point at the secured.mdw?

Put the mdw that you secured it with on the server. Give each user a
shortcut to launch the secure mdb. It's target would look like:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"



--
Joan Wild
Microsoft Access MVP

Are you following a written list of explicit instructions? It's too
hard to get it right just by using the help files, for example. If you
haven't already seen it, read the Access security FAQ, often referenced
in this newsgroup.

HTH,
TC

Hi Joan,

Thanks for your help...

Currently the users can access the database without a password. The mdw
file is on the server but I think they are gaining access from their default
mdw file. I have followed the steps within the MS Access FAQ but this
doesn't tell you how to join the mdb to the mdw for the users on a network?!


"Joan Wild" wrote:

> Craig C wrote:
> > I have created an Access database which is distributed onto a Network.
> > Currently I have created all the users which can be accessed only
> > from my PC, but the security permissions and passwords don't work
> > when the users access the database.
>
> When you say 'don't work' do you mean they can't access the database? If
> so, that's good, they shouldn't be able to unless they use the correct
> workgroup file.
>
> > I have attempted to "join" the
> > users to the secured.mdw file but it appears to be pointing at their
> > default system.mdw file.
>
> Why do you think it's pointing to their default system.mdw file after
> joining them? Anyway, it doesn't matter; you shouldn't change their default
> workgroup file as that will impact all databases they use.
>
> > Does anyone know how I can make the users
> > point at the secured.mdw?
>
> Put the mdw that you secured it with on the server. Give each user a
> shortcut to launch the secure mdb. It's target would look like:
> "path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"
>
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
>

Hi TC,

Yes I followed the MS Access security FAQ but there doesn't appear to be
anything about to to implement this onto a shared site?

"TC" wrote:

> Are you following a written list of explicit instructions? It's too
> hard to get it right just by using the help files, for example. If you
> haven't already seen it, read the Access security FAQ, often referenced
> in this newsgroup.
>
> HTH,
> TC
>
>

If users can access the database without logging in then you missed a step
in securing it. Every step (phrase, in fact) is essential - you can't miss
anything.

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm

The fact that you are making it shared on a network is not the problem here.

--
Joan Wild
Microsoft Access MVP

Craig C wrote:
> Hi Joan,
>
> Thanks for your help...
>
> Currently the users can access the database without a password. The
> mdw file is on the server but I think they are gaining access from
> their default mdw file. I have followed the steps within the MS
> Access FAQ but this doesn't tell you how to join the mdb to the mdw
> for the users on a network?!
>
>
> "Joan Wild" wrote:
>
>> Craig C wrote:
>>> I have created an Access database which is distributed onto a
>>> Network. Currently I have created all the users which can be
>>> accessed only from my PC, but the security permissions and
>>> passwords don't work when the users access the database.
>>
>> When you say 'don't work' do you mean they can't access the
>> database? If so, that's good, they shouldn't be able to unless they
>> use the correct workgroup file.
>>
>>> I have attempted to "join" the
>>> users to the secured.mdw file but it appears to be pointing at their
>>> default system.mdw file.
>>
>> Why do you think it's pointing to their default system.mdw file after
>> joining them? Anyway, it doesn't matter; you shouldn't change their
>> default workgroup file as that will impact all databases they use.
>>
>>> Does anyone know how I can make the users
>>> point at the secured.mdw?
>>
>> Put the mdw that you secured it with on the server. Give each user a
>> shortcut to launch the secure mdb. It's target would look like:
>> "path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"
>>
>>
>>
>> --
>> Joan Wild
>> Microsoft Access MVP