I am using Access 2003 and would like to be able to retrieve the Date
and Time of the PC where the backend MDB is stored, from the front
ends (MDE) which would reside on different PCs.

Any ideas.

John

john (AT) kosmosbusiness (DOT) com wrote:
There is a link at http://www.mvps.org/access/api/api0039.htm. However,
it's for NT. I figure, from this code, that it would be an API call.
Perhaps look for an API in google or google groups for determining it.

You are right on both counts. An API that can be used is NetRemoteTOD
as indicated in the call below.

p_lngRtn = NetRemoteTOD(yServer:=p_abytServerName(0),
pBuffer:=p_lngPtrBuffer)

However there is a 5-6 second delay when invoked, which is
unacceptable.

Any ideas?

John

john (AT) kosmosbusiness (DOT) com wrote:


I have no idea if this would work. What would happen if you wrote a
file to that server. (Fopen, Fwrite, Print #, Fclose, etc). Just a one
line file. Then did a dir on that file and determined the the timestamp
of the file. Ex from A97 help
Dim MyStamp
' Assume TESTFILE was last modified on February 12, 1993 at 4:35:47 PM.
' Assume English/U.S. locale settings.
MyStamp = FileDateTime("TESTFILE") ' Returns "2/12/93 4:35:47 PM".
'my addition so you leave the folder uncluttered.
Kill "Testfile"

I assume it would be a timedate on the other computer, not the local one
that invoked the file creation. Of course, one would need network
rights to create the file for testing.

Excellent. This is exactly the functionality I am looking for. In
other words when I write to the backend I need that timestamp inserted
in the front end.

Great lateral thinking.

John

Salad <oil (AT) vinegar (DOT) com> wrote:

FWIW the first place I look for API stuff is at vbnet.mvps.org. Rather than doing
what is usually a useless search with too many useless hits from Google as Google now
indexes every online forum which is a mirror of the NNTP newsgroups.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

"Salad" <oil (AT) vinegar (DOT) com> wrote


The above works if you have just about any kind of windows box (windows xp
for example).

I not sure if the server can be windows xp home, but it works for xp pro.
And in fact I have clients of mine in which their server is a linx box (that
means Samba - and again it works).

So, virutally just about any office setup with a sewrver will work.

And, I found there not a big delay when you use this api...

So, it not limited to NT and just about any windows box after NT also
supports that api...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal (AT) msn (DOT) com

Albert D. Kallal wrote:

run on his PC which made it unacceptable...why it took so long is beyond
me...maybe it's a wan?