LogOn form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M!$HU - 16 Jul 2007 09:08 GMT

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 :)

Reply to this Message

Daniel - 16 Jul 2007 16:12 GMT

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.

Signature

Hope this helps,

Daniel P

> 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 :)

Reply to this Message

M!$HU - 17 Jul 2007 07:22 GMT

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???

Reply to this Message