Mansoor Ahmad
Registered User.
- Local time
- Today, 12:21
- Joined
- Jan 20, 2003
- Messages
- 140
I have a MS database with user lever security in place. There are two users in users group and two in Admin group. But there seems to be something wrong with it. If two users (one admin and other user) are entering data at the same time at different machines, after some time when user go to new record, the database like jams, would not allow to select anything and a bit later displays that ‘currently locked cannot update.’ But it does not happen on Admin user. I cannot work out how to make it right?
The requirements for my database are
1. There can be 3-4 users inputting data at the same time.
2. Each user need to have a password protected access to database with limited permissions.
If anybody has any ideas about this or some system of effective security method, please give some help.
The requirements for my database are
1. There can be 3-4 users inputting data at the same time.
2. Each user need to have a password protected access to database with limited permissions.
If anybody has any ideas about this or some system of effective security method, please give some help.