I want to use the security levels in ms access..
Iam having 5 main user who are using the database and doing the entries and updation and viewing report ect.
Expand|Select|Wrap|Line Numbers
- i.e. they are all five seperate division in my office
I build the only one table to entry data ...but i use 5 seperate report to view their report ... the issue is these report can view by clicking an command button when the user entered into database they can view any one data by clicking the button... but i want to set an protection to restrict them by their longin ID if they entered the database they should have the accessability to their datas not the others..
Please any body help me if your not able to understand please revert me..
thanks in advance..
anukanuk