Server Date

[Guest]

I am developing a Network application using VB.NET & Access. For logging
purposes, I needed the server date, perform some manipulations on it & store
back the result to the server, for which I developed a procedure in VB that
executed the query
'Select Now'
with the connection string containing the path of the database on the server.

I expected the procedure to return the Server date. But to my great
surprise, it returned the local system date & time.
I suspect the File serving nature of Access to be the culprit.

Anyhow, I strictly need the server date for my purpose....
How can I retrieve it????

 

[Arvin Meyer [MVP]]

Access runs on the local machine, unless you are using Terminal Services.
You'll need a server side script to do what you want. Try finding one at:

http://www.tdscripts.com/

 

[Douglas J. Steele]

You'd be better off asking in a newsgroup that's related to VB.Net, since
Access uses VBA, not .Net

In VB and VBA, you can use the approach outlined in
http://www.mvps.org/access/api/api0039.htm at "The Access Web"