Showing Current User Detail
I have an employee details table. And I am attempting to show the employee detail through a data access page by determining the current user name.
I have created a query where EmployeeID = Environ("UserName").
It works when previewing in Access. Yet it failed when I actually run the data access page in IE, with the messages "Data provider failed while executing a provider command", and "unknown function" immediately after. Can somebody tell me what's happening and how I can resolve this?