Hi all,

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?

I don't know much about data access pages, but from the sound of your description, it seems that the function Environ() is unknown to IE. Is there an equivalent function you can use that IS known?



Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division