Ms Access Database Timestamp

Dear Experts,

I created a client-server based application in MS Access.
On the server side runs a scheduler which releases tasks every minute in the On Timer event.
After the tasks have been released, the scheduler puts the current date and time (Now()) in a table.
On the client side, there is a monitor who checks if the scheduler is still running.
To make sure the scheduler is running, the client application compairs the timestamp on the client side (also now()) with the value entered in the table by the scheduler on the server side.

Issue is that the server and client computers have different timestamps. Sometimes more than 5 minutes.
Now I was wondering if there is a way to get the timestamp of the database. I know that in an Oracle database you can select the timestamp from the DUAL. Is there a way to do this in Ms Access?

If not, I might consider upsizing the application to Ms SQL Server.
But than again the same question ; Is there a way to select the timestamp of Ms SQL Server?

Thanks in advance.

Regards, Johan
LVL 1
jrameuwissenAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Patrick MatthewsCommented:
Hello jrameuwissen,

With respect, Access is *not* a db server, and so there is no possibility of constructing a true client-server
architecture using Access as the db layer.

OTOH, SQL Server, MySQL, Oracle, DB2, etc are all true database servers, and if you want to build a
client-server app, those are the platforms you should be looking at.

Regards,

Patrick
0
jrameuwissenAuthor Commented:
Patrick,

I just tried to indicate that the database and the application are running on seperate machines.
In case the database was a SQL Server, how could I select the timestamp of the database from within a query?

Thanks, Johan

0
Patrick MatthewsCommented:
Johan,

That depends on how you are passing in the data.  To use the server's system time, your query (or, even
better, stored procedure) should use a function such as GETDATE.  To use the client's system time, you
would need to gather that information from the client OS in the application layer, and pass it as a ststic
value to the query/sproc.

Regards,

Patrick
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jrameuwissenAuthor Commented:
Patrick,

My excuses for my late response.
I migrated the data to SQL server and use a stored procedure now. It works fine.
Thanks for pointing me in the right direction.

Regards, Johan
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.