Get date/time from internet

[cj-1289]

Hello, I have a database which relies heavily on VBA references to the present time and date as stored by their local system. However, one of the computers is incapable of storing local date/time information for very long, even with a new battery, and we're not authorised to simply replace that machine. I would like to instead create a VBA reference to an internet clock to circumvent the issue, or at least to correct the local clock on the fly each time in order to allow the present local references to work universally, but thusfar I haven't found anything that works for me. Can anybody help? Thanks in advance.

 

[jdraw]

This is the place to start.
http://vbnet.mvps.org/index.html?code/fileapi/filedatetime.htm

 

[cj-1289]

Thanks for the reply. I'm afraid I don't see how a procedure to change the date/time property of a file is relevant to a way of fetching the current time from an internet clock though.

 

[PeterF]

Why not sync the computertime with a NTP server instead of coding it in VBA.
See Microsoft knowledge base