cdoyle[ at ]oz.net wrote:
[Quoted Text] > Something has come up here, where it might be needed to have one of my
> DAP's only display info depending on the user.
>
> What we have is a DAP that lets you look up time off for each employee.
> Right now, any user can look up any other users time off. Some are
> not liking this, and would like only themselves be able to search for
> their own time off ect.
>
> Is there a way to accomplish this? Maybe somehow pull their network ID
> and match it too a entry in a table in my DB?
>
> Or I guess a user ID and password type thing for each employee?
>
> This sounds like it will be a nightmare to manage, but thought I would
> ask.
I have the same problem because I want to do the same with my database.
I used a functions which give me FirstName and LastName of the user
currently working (login) (it takes it from ActiveDirectory from
server) and put tkis functions as a criteria in query. But it works
only in DAP running from MsAccess, not directly from IE.
If you will fix it, write solution, please
|