Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 305
  • Last Modified:

Get server time for MS Access Field

I have a split database in Access 2003 with the main tables residing on a local server.  I am trying to create an employee punch/in and punch/out time clock.  I'd like to take the time from the server for a form now() function so users could not change their desktop time.  Anyone know of a simple way to do that in VBA... ?
0
limobill
Asked:
limobill
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Are you hosting your tables in Access, or in a server-type database?

If they're in Access, then I'm not sure you can do this. All processing is done on the workstation, and there is no capabilities on the "server" portion to run code.

If you've moved them to a server database, then you could use one of the native server methods. For example, in SQL Server you could create a StoredProcedure that would return the Server time.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now