users over network

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
aaron b said:
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,
Click to expand...

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
 
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.
 
Back
Top