LogOn form

[M!$HU]

Hi,i'm Mishu and I need to build a logon form, where users who logon can edit
the DataBase,and the ones who have no account can only view the content of DB.
The second thing is that I need a form where users logged on can upload and
download files to/from the DB. Sorry for my bad english

 

[Daniel]

You need to implement User Level Security (ULS) it will allow you to create
accounts for your users and control what they can access and do within your
database.

Google the term 'Ms Access User Level Security' and you will get lots of
information. Also, read the help section on this.

 

[M!$HU]

Thanks for your answer.But,I want to do this with from the code writen on the
form at a button click.Let me show you:
Private Sub OK_Click()
If Len(txtUser) = 0 Or Len(txtPass) = 0 Then Exit Sub
strPassword = DLookup("[Password]", "Users", "[UserName] = '" & txtUser
& "'")
If strPassword = txtPass Then
' Password matches:
Form_Employees.AllowEdits = True
DoCmd.Close
MsgBox ("Welcome!")
Form_Employees.AllowEdits = False
Form_Employees.AllowAdditions = False
Form_Employees.AllowDeletions = False
Form_Employees.AllowDesignChanges = False
Form_Employees.AllowFilters = False
Form_Employees.AllowFormView = True
DoCmd.OpenForm ("Main_Switchboard")
Else
' Password DOES NOT match:
MsgBox ("Check UserName and Password")
End If

'ErrorTrapping not shown
End Sub


So those functions:AllowEdits,AllowDeletions etc. don't work.Innitialy my
form Employees is Editable so when a guest is watching the DB content the
form will be read-only. What do you think???