Can any one tell me how can i make privileges for user to restrict them and only administrator have all rights.

Please help me
Thanks in advance.

Will this be an administrator within your application or the windows administrator?

Ok can you provide me sample coding for login a user by checking user exists in users table i have tried but no luck

i am trying some thing like this

dim db as database
dim rs as recordset


on form load i am connecting with database like this
my connecting string here and
set rs = db.openrecordset("Users")

Then i used this coding on btnlogin

select query here

but i didn't successed i please help me waiting for you reply

Try the following -

Dim cnPrint As ADODB.Connection
    Set cnPrint = New ADODB.Connection
 
    Dim rsPrint As ADODB.Recordset
    Set rsPrint = New ADODB.Recordset
    Dim MyCon As String
 
    MyCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\MyData.MDB;Persist Security Info=False"
 
    cnPrint.Open MyCon
 
    If rsPrint.State = adStateOpen Then rsPrint.Close
 
    rsPrint.Open "SELECT * FROM MyTable WHERE UserType =" & "'" & text1.Text & "'", cnPrint, adOpenStatic, adLockOptemistic

    'Or

    rsPrint.Open "SELECT * FROM MyTable WHERE UserYesNo =" & "'Yes'", cnPrint, adOpenStatic, adLockOptemistic

Put all of the above code under ONE event, say a button click event.

Ok i would try and let you know if could have any problem thanksfor your reply

I have resolved it thanks for yuor help

commented: For not giving up to find a solution. +4