Access Security over a network?

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

Guest

I have created a workgroup and security for my Database, but I was wondering
how you make that work over a network. My Database is form based, I have
split the database into Front end and Back end. The Back end sits on a shared
folder everyone has access to. The problem Im faced with is I can set the
security on the front ends individually, but how do I do that over the
network for all front ends?

Richard C
 
Richard said:
I have created a workgroup and security for my Database, but I was
wondering how you make that work over a network. My Database is form
based, I have split the database into Front end and Back end. The
Back end sits on a shared folder everyone has access to. The problem
Im faced with is I can set the security on the front ends
individually, but how do I do that over the network for all front
ends?
Click to expand...

Secure your frontend using your workgroup file. Put the workgroup file in
the same folder as the backend (ensure you don't give it the same name as
the backend mdb). Copy the secured frontend to the users and give them a
desktop shortcut to launch it.

The target of the shortcut would look like:
"path to msaccess.exe" "path to frontend" /wrkgrp "path to secure.mdw"

You can use a UNC pathname for the mdw, so you don't have to rely on
correctly mapped drives.
 
Back
Top