Implementing user-level security on a network

B

Bill

I have created user level security on a database located on a network. How do I point to this to allow other users to log on?
 
J

Joan Wild

Hi Bill,
I have created user level security on a database located on a
network. How do I point to this to allow other users to log on?

Assuming you mean that you have copied the mdw and mdb to a shared folder
(where all users have read,write,create,delete permissions), you can give
each user a desktop shortcut. It's target would look like

"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

You can use UNC pathnames in the above.

In addition, if you haven't done so yet, you should split the mdb and leave
just the backend on the server. Give a copy of the frontend to each user on
their local harddrive. The frontend will contain links to the tables in the
backend.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top