As many of you know currentwebuser(x) can be used inside your Access Web Database as follows:
0 gives current user’s member ID.
1 gives current user’s display name.
2 gives current user’s login name
3 gives current user’s e-mail address.
The FAQ that we have been getting is “How do I define this information to SharePoint 2010?” or “How can I allow my users to self-maintain their current/preferred email address and use that as a variable inside my Access 2010 Web Application?”
Here is a short video which shows how to do this and how to change your time zone to eliminate the errors that occur when your native time zone is out of sync with the server.