Hi:
I have created a database which will be used by 5 users. My problem is that there are records related to each user in the database.
I want that when a user opens the database he should be able to see the records related only to him and not the records related to other users.
Out of these 5 users only 1 user will have access to the entire database. He should be able to edit records or add new records. But the other users should be able to edit only their records but not be able to add a new record.
What other things I need to take into consideration for multiple users using the database?
I have never done this before so I need some guidance.
Thanx
Ekta
I have created a database which will be used by 5 users. My problem is that there are records related to each user in the database.
I want that when a user opens the database he should be able to see the records related only to him and not the records related to other users.
Out of these 5 users only 1 user will have access to the entire database. He should be able to edit records or add new records. But the other users should be able to edit only their records but not be able to add a new record.
What other things I need to take into consideration for multiple users using the database?
I have never done this before so I need some guidance.
Thanx
Ekta