Sunday, November 30, 2008

MS Access Can Handle Millisecond Time Values

Manipulating time values with millisecond precision in Access requires some crafty programming. You need the help of a couple of API calls, which you wrap in functions that mimic the standard timing functions in Access. In Access, the built-in timing function with the highest precision is Timer(), but the resolution is only 1/64 second, or about 16 milliseconds. You need a custom timer function to achieve a higher resolution. An essential trick that makes this possible is the conversion between native and linear time. I was wondering what needs to measured in milliseconds. Maybe Olympic races?

No comments: