Security on Multiple Computers

[JudithJubilee]

Hello there,

I have set up user accounts and granted permissions for
them in my database. I would like to know how to transfer
those permissions to the users' computers. Do I have to
just put the database in a shared folder and the
permissions go with it?? I'm sure there is another
stage.....

This is what I have done so far:

1. I set up a user account for myself and made myself a
member of the Admins account.

2. I removed the Admin user from the Admins account.

3. I set permissions for the User account and the Admin
account.

4. I added 2 users who are only members of Users.

5. I logged in as each of my users and changed the
passwords from blank to better ones.

6. I changed the owner of all objects to myself and not
Admin.

If someone can help me with the last step it would be
much appreciated!! I am using 2000 in this instance but
will be using 97, 2002 and 2003 with various companies.

Judith

 

[Joan Wild]

Hello there,

I have set up user accounts and granted permissions for
them in my database. I would like to know how to transfer
those permissions to the users' computers. Do I have to
just put the database in a shared folder and the
permissions go with it?? I'm sure there is another
stage.....

Usually you would split the database and put the backend on the server,
along with the workgroup file. Give each user a copy of the frontend on
their computer.

This is what I have done so far:

snip
Those steps, as outlined, would not make your database secure. The very
first step is to create a new workgroup. It sounds as though you modified
the standard system.mdw that ships with Access. Undo what you did, or go
back to the backup you made before you started, and start over.

Follow the steps *exactly* as outlined in the FAQ
http://support.microsoft.com/?id=207793

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm

If someone can help me with the last step it would be
much appreciated!! I am using 2000 in this instance but
will be using 97, 2002 and 2003 with various companies.

Since 97 is the lowest version, you should be developing in it. 97 users
will not be able to use your 2000 version of the mdb.

 

[Beenish]

It's a good idead to create seperate folders. It makes the
information organized and easier to use.