dlookup again

[krishnanhemanth]

i can get the windows user name on the textbox of a form

i have a table tblemployeelogin
fields are
employeeid 1
employeename tony
accesscode 1
accessrights readwritemodify

the accesscode and accessrights are like this

1 readwritemodify
2 read
3 write

what i want is

once the form loads, it should check the user name and compare it with the above table and restrict or allow data read/add/modify as per accessrights

how can i do this
i get the user name using fosusername()

please help

hemanth

 

[Trevor G]

Surely the group and admin permission part of access will deal with this when a user logs into the database?

 

[smig]

you asked exactly the same things 3 days ago:
http://www.access-programmers.co.uk/forums/showthread.php?p=999690#post999690

just put the permissions in the other columns.

as for using these globaly:
you can either declare a global variable, or save the data to the registery.