Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old November 1st, 2005, 07:54 PM
Registered User
Join Date: Nov 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Showing Current User Detail

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?
Old November 2nd, 2005, 05:16 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
How Can I Get the Name of the Current User? BrianWren Beginning VB 6 1 March 27th, 2007 12:28 PM
How Can I Get the Name of the Current User? BrianWren Pro VB 6 0 March 27th, 2007 11:42 AM
Code showing current datet& time of server pareshk Wrox Book Feedback 1 June 6th, 2005 10:06 PM
Current user type dotnetprogrammer VS.NET 2002/2003 0 February 1st, 2005 07:20 AM
current user schockp Oracle 2 November 12th, 2003 06:18 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.