Passwords / Security (Help!!!!)

[Richio]

I need to set up some sort of simple (!!!) security / passwords on a database used over a network.

To be honest I have read too many horror stories on user level security (lock outs etc) and the database is such a fundamental part of the business to "play around" with if it all goes wrong.

What I want is simple.

Imagine the database.....one huge table with all the info in it. All the info is related to each customer Ie one name / number with 60 odd related fields.

All the info is input on one form over 6 different pages (each page with a seperate icon / tab)

I now need to store sensitive info related to the customer on a seperate page but in the same table. Ie so if you click on the icon / tab for that page it asks for a password before this area can be accessed.

The whole database at the moment is protected by the shift key, so users only have access to the form / reports and can't access the design views / visual basic etc etc

Any ideas would be greatly appreciated

 

[Treason]

Richio, here's my 2 cents

I think Access Security is the solution for what you want to do. All you need to do is setup a group account and a private account, then only give rights to that form on the private account. That way, if you login with the correct username/password you can access that form, otherwise you cannot.

I suppose thier is VB security you can setup also, but if VB is french to you then go with access...

Hope this helped
Treason

 

[DBL]

I've attached a password sample that you might be able to adapt. I use it as the form on Start up and the users have to log in and depending on their access department they can have full or restricted access to various forms and events - like adding to lists, etc.

The password for Lawson Dawn is test99. I can give it in 97 if needed.

 

[Richio]

Many thanks for the replies, I will see if I can crack it .