User-Level secruity help

[bhcob1]

Hi,

I need to add secruity to my database.

I would have just a Database Password, except this gives all users admin rights.

There are going to be 2 types of users

Admin and Read-Only

I was going to use User-Level Secruity Wizard to create this except i am under the impression that this means that you cant copy the database and drop it in diferent folders etc.

As a few of my users will be in France and a few in Australia, they where planning to copy it about once a day.

Is there any way the User-Level Sectuiry databases can be copied.

ANother question, could i just make a simple form on database open that asks for a login and password, (only 2 users Admin and Read Only), and then for every form set allowedits etc to the appropriate condition depending on the user.

Thanks

[MMcCarthy]

This is a complicated issue.

Have a look at this website as it provides comprehensive information.

http://www.jmwild.com/Accesssecurity.htm


Mary

[NeoPa]

Hi,

I need to add secruity to my database.

I would have just a Database Password, except this gives all users admin rights.

There are going to be 2 types of users

Admin and Read-Only

I was going to use User-Level Secruity Wizard to create this except i am under the impression that this means that you cant copy the database and drop it in diferent folders etc.

As a few of my users will be in France and a few in Australia, they where planning to copy it about once a day.

Is there any way the User-Level Sectuiry databases can be copied.

ANother question, could i just make a simple form on database open that asks for a login and password, (only 2 users Admin and Read Only), and then for every form set allowedits etc to the appropriate condition depending on the user.

Thanks

Unless you need to stop all sorts of potential access to the data, then handling this in code (driven by a logon type form) may well be a viable solution.