Question splitting

[joe1987]

Hello,


is there a way to split db in such way, that each individual front end user can see information that only he entered, and the back end user (suppose it's head office) could see information all users entered?

[pdebaets]

You would split the database into front-end and back-end normally. The way to have each user see only their own records is to have the users sign on using a sign on form, then include the sign on ID in each of their records. Then set a filter so that when the user opens a form they only see records with their sign on. At the "head office" the user could sign on with an "Admin" ID that would allow access to all records. We have a product at our site called LASsie that will do much of this work for you, and the demo contains an example of this exact scenario.

You can also get the windows user name using this function http://access.mvps.org/access/api/api0008.htm and insert that into the records, but I've found that many users don't stick with one windows username, or the user name corresponds to the computer, not the user.