users over network

[Guest]

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,

 

[Keith Wilby]

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

 

[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.