Security Questions

[pleg12345]

Please can anyone help....

Hi im just building a new enquiry database which will be used by about 10 people, which will be stored upon a server.

Each user that opens a database i would like a username/password to stop unathorised access to the database.

Q1. What is the best way to create a UserName Password? using access security?

When the User logs on, i would like it to take them to their own personal area.

Q2. Would i just be able to create one general form, which is personalised depending upon who has logged on?

On their personalised area i would like a button to take the user to add a new record. I would also want another button to allow them to edit only their own queries.

Q3. By only editing their own queries, would this involve using a filter?


Hope someone can advise?

 

[KenReay]

Hi

A lot of questions there

Using Access security theer is only one way to set up the password prompt, that is put a password on the admin user or the workgroup file, once you do that all users will be prompted for a user id, (user) password may if you wish be blank.

Why not consider using Windows log in to check for valid users, saves a login step

"Normally" when you have a shared db you split it into two mdb files, the Backend (BE) contains the data (eg tables) while the frontend (FE) contains the user interface eg Forms, queries, reports etc and links to the tables in the BE.

The FE is stored on each users PC, the BE is stored on a network share

Any Queries created by the user would be saved in the FE.

You can personalise the form based on the userId eg show hide controls, buttons etc jsut as much as you are willing to code, subject to max number of controls on a form etc

I assume you mean only editing their own data rather than queries?, yes you could do that by a filter based on the user id or by a record set based on a query which has a criteria of user id and each row having an identifying user id as its "owner"

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK