Results 1 to 6 of 6
  1. #1
    Humberto is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    2

    Question Get Date and Time from a Domain Controler

    I would like to be able to get the Date and Time from the Domain Controller and place it on a form.

    Humberto

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    What is the difference between that time and the time in Access?

  3. #3
    Humberto is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    2
    The difference is that Access gets the local machine's (desktop) time, which can be easily manipulated by the user. I have a Sign In/Out application and I do not want users to be able to manipulate the sign in/out date/time.

    Humberto

  4. #4
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    I found an answer which states:
    Environment variables are a very unreliable way to verify the user because they can easily be changed from the default by the user. Better to get the actual information:

    LoginName = CreateObject("wscript.network").UserName
    MachineName = CreateObject("wscript.network").ComputerName
    There was no further information, however. And I cannot provide any more as it isn't in my knowledge base! It may be a place to start.

  5. #5
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Here is a long shot:

    API: Retrieve NT Server's Time
    http://access.mvps.org/access/api/api0039.htm

  6. #6
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    the local machine's (desktop) time, which can be easily manipulated by the user.
    It's interesting that the IS/IT department has not locked the typical user out of the time clock app. That's a basic practice AFAIK.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 04-19-2016, 03:58 PM
  2. Replies: 11
    Last Post: 07-20-2014, 06:22 PM
  3. Subtracting a date/time field from a number to get date/time
    By Lifeseeker1019 in forum Programming
    Replies: 4
    Last Post: 03-28-2014, 12:59 PM
  4. Replies: 1
    Last Post: 03-13-2014, 07:23 PM
  5. Replies: 6
    Last Post: 01-04-2011, 05:43 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums