restrictions for different users

[joe1987]

Hi,


I'm coming back with the same question as I haven't been able to find a solution to this one. I have my data base splitted in to front/end. There's login form implemented retrieving username and password from a table. There're couple of restrictions like: admin - can delete records; non admin - can't delete records. But my main purpose is to have such restriction that each front user will see the data entered by him only and back end should reflect all data entered by different front end users.
Can anybody help me on this?
I would appreciate clear and understandable explanation on how to do this.

[pdebaets]

You'll need to keep the user name in a table field. Then you'll need to filter your forms when they open to just show the records for the current active user.

[joe1987]

You'll need to keep the user name in a table field. Then you'll need to filter your forms when they open to just show the records for the current active user.

How should I have to filter so? Is this a code or access implemented function?

[pdebaets]

Here's an example (from your OnOpen event procedure):

Me.Filter = "CustomerID = 1"
Me.FilterOn = True

[joe1987]

Here's an example (from your OnOpen event procedure):

Me.Filter = "CustomerID = 1"
Me.FilterOn = True

That's really helpful as I don't even know how to form onopen procedure...
Thanks anyway...

[aytee111]

There is a loophole in using filters as if they are not switched off the used can un-filter manually and then they can see all records. Rather put it in the record source of the form (WHERE username=login)

[pdebaets]

Here's some info on how to create an event procedure: http://peterssoftware.com/faq.htm#quiz2

[joe1987]

Here's some info on how to create an event procedure: http://peterssoftware.com/faq.htm#quiz2

Thanks, will try