Home All Groups Group Topic Archive Search About
Author
18 Oct 2007 2:07 AM
aaron b
Hi all,
I have currently set security (users and privileges) on my mdb and all is
running well on my PC. however another user accesing the same mdb over the
network cannot even attempt a logon, before getting an error message. The
security.mdw file is in the same network folder as the mdb file.

How do I change this so other users on the network can have the same
security as my own machine?

thanks in advance,

Author
18 Oct 2007 8:03 AM
Keith Wilby
"aaron b" <aaron b@discussions.microsoft.com> wrote in message
news:C37EC1D4-AF4B-47F5-BA46-ADEB10371E7D@microsoft.com...
> Hi all,
> I have currently set security (users and privileges) on my mdb and all is
> running well on my PC. however another user accesing the same mdb over the
> network cannot even attempt a logon, before getting an error message. The
> security.mdw file is in the same network folder as the mdb file.
>
> How do I change this so other users on the network can have the same
> security as my own machine?
>
> thanks in advance,

You and your users should stay joined to the default "system.mdw" workgroup
and switch to it on a session-by-session basis using a shortcut in the
format

"Full path to MSACCESS.EXE" "Full path to your app.mdb" /wrkgrp "Full path
to your workgroup file.mdw"

including the quotation marks.

Keith.
www.keithwilby.com
Author
18 Oct 2007 2:11 PM
Joan Wild
In addition to Keith's advice, make sure that your mdw file does not have the same name as the mdb.  Each needs to create their own ldb.

--
Joan Wild
Microsoft Access MVP
Show quoteHide quote
"aaron b" <aaron b@discussions.microsoft.com> wrote in message news:C37EC1D4-AF4B-47F5-BA46-ADEB10371E7D@microsoft.com...
> Hi all,
> I have currently set security (users and privileges) on my mdb and all is
> running well on my PC. however another user accesing the same mdb over the
> network cannot even attempt a logon, before getting an error message. The
> security.mdw file is in the same network folder as the mdb file.
>
> How do I change this so other users on the network can have the same
> security as my own machine?
>
> thanks in advance,