How to creat user account and give limited access

[Shams]

I have created Students Database using tamplat, now I want to creat some user
account and give limited access to the data. Like I want Mr. John to Enter
Data but He should not edit any data in that database and I want Ms. Lora to
have full access to the database.
Please note I dont have any experience in SQL Server.

Thank you
Shams

 

[PKJoshi]

Dear shams,
You may keep user information like ID, name, password &
Permissions(Full/Limited/View only etc) in a table in secured database.You
may even maintain saperate db for this purpose. Now in a saperate module
containig global variables retrieve these data such as user login status,
permissions etc into appropriately defined variables. These variables can now
be used throughout your application for opening the forms/controls in
proper-modes for a given user. A good read is "Access 2007 Inside
Out"(Microsoft Press) for insight and code example.
I hope it would help you.

-PKJoshi