Get date from Server? 1

[evalesthy]

I have some forms that I would like to lock if record was not created today (or within last x number of days). Obviously, this is easy to bypass by user if I just check desktop date as they can reset their desktop date. Getting date form server would be a better option. Is their a simple way to do this in code?

 

[vickero007]

What code are you using to access your DB? Any server-side code is going to pull the server's date/time with a standard function like Now() or Date() depending on which language you are using.

-Volkoff007

http://www.middleriver.org

http://www.onestepministries.org

http://www.h2olive.org

 

[evalesthy]

For example. In the front end (split database) if I call Date() in the form onOpen event it returns the front end (desktop) date setting, not the server date setting.

So, if I run a little test like:

If Me.EnteredDate <> Date()

could easily be fooled by user resetting desktop using "Adjust Date/Time".

 

[RoyVidar]

I've once used the (perhaps a little dirty) approach of creating a text file on the server, then reading the DateLastModified property from it, using the filesystemobject, then deleted the file (to avoid concurrent access to the same textfile, I used a randomized name - part of username and timestamp).

Roy-Vidar

 

[evalesthy]

Roy: Thanks. If I don't come up with another way I may ask for your help with the coding. Clever work around - but isn't there some easier way to call the Server settings? Beyond my scope of knowledge but seems logical to me.

 

[RobertT687]

Here's a trick that may work for you.

Create a Pass-Thru query referencing a small linked table on your server.
Here's the code I used to get the Server datetime.

Select Getdate() as ServerDate, Count(*) As MyCount From MyLinkedTable;

You could execute this, save the result and do your compares from there.