[AccessD] Time Synchronization

I wrote a sync program in VB.  You could use it in Access, just uses the
Winsock control.

Drew

-----Original Message-----
From: mnptl at sonmedia.com [mailto:mnptl at sonmedia.com]
Sent: Tuesday, November 02, 2004 2:21 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Time Synchronization


Hi Chris - yes, TECHNICALLY that would be a lot easier!  PROCEDURALLY,
that could take months!  I'm currently assisting a pharmaceutical company
with ensuring that they meet all FDA regulations, especially those
concerning electronic records.

The concept of handling their time synchronization in a centralized way is
somewhat new, and will have to go up the chain of command to head office,
mulled over, a policy put in place, local IT procedures created, and then
the technical controls instituted...  a very long process.

I was hoping that there was something similar to:

command.com /c net time \\<servername> /set /y

that could use for synchronizing the local machine's time to a "standard"
clock available on the Internet, such as NIST.  I tried the command above
with:

command.com /c net time \\129.6.15.28 /set /y

... (which is one of the NIST time server IP addresses) but with no
success.  It CAN be used for synchronizing with the back-end server, but I
was hoping for something more thorough!

Let me know if you know of any other way.

Thanks,

Mark

-----Original Message-----
From: "Foote, Chris" <Chris.Foote at uk.thalesgroup.com>
Subject: RE: [AccessD] Time Synchronization

Hi Mark!

Would it not be easier to synch the clock on the host machine with a NTP
server and then get that via Date() Time() etc?

Or does the time function need to be totally encapsulated in the Access app?

Regards!
Chris Foote

-----Original Message-----
Sent: Tuesday, November 02, 2004 5:39 PM
Subject: [AccessD] Time Synchronization

Does anyone know of any VBA code to be placed within an Access application
that can easily poll an Internet-based time server, and return that time
to a variable?  Searching through the archives hasn't come up with
anything ... yet ...




-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com