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?
within my application
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
Its a pleasure.:)