Security - controlling external user access to data

[mdr]

Hello, I'm trying to identify whether Access is the right tool for my requirements:




Objective: Regularly gather info from our Partners on their marketing campaigns
Users: ~100 individuals outside of my employer organization
Requirements:
1. Use of a form for data entry
2. Ability for the external user to see what information they've already entered - WITHOUT seeing the data entered by our other Partners

Is that possible with Access?

Thanks,
mdr

[ranman256]

In the db, I have a tUsers table, with userID, Name, and Level
USERID, Name, LEVEL
bob12, bob smith, M
pam4, pam jones,""
xman1, charles xavier, A




when user opens the db, the main menu form will open and grab the userID.
Then lookup that persons rights in order to enable/disable controls.
put the UserId into an invisible text box on the form,txtUserID , so queries can see it.

public gvUserID 


sub form_load()
dim vLevel


   gvUserID =  Environ("Username")      'get userID,visible in all forms


'get level from user table
   vLevel = Dlookup("[Level]","tUsers","[userID]='" & gvUserID & "'")


'now, enable/disable items on form
   select case vLevel
         case "A"  'admin 
             'all is enabled


         case "U"  'normal user
             txtBox1.enabled = false
             txtManager.enabled = false


         case "M"  'manager
             txtBox1.enabled = false
   end select
end sub

now use queries that filter on the textbox txtUserID so users can only see THEIR data:
select * from table where [userid]=forms!fMyform!txtUserID


or join a table with the users lists and what they can open.

[mdr]

ranman256, you are the man! Thank you!