By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,566 Members | 1,659 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,566 IT Pros & Developers. It's quick & easy.

Date/time, multiple location problem

P: n/a
Hello,

We have a set of Access databases that we extract data from into a
centralized Oracle database. We have a copy of this database in San
Francisco, New York and London. The SF and NY team actually use the
same one over the lan. Anyways, we have a date updated field that
basically used the form update event to set it to now. Is there an
easy way to set this value based on geographic location. Basically,
NY -5, SF -8 (or -7 for DST) -0 for London, etc.

The reason is that we need to sync some data from Oracle to and from
the access database a couple times a day and we also need to see what
records have changed (as we are only sycning parts of the data and
certain records).

Any ideas/help would be greatly appriciated.

Thanks,

Gary Smith
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Gary Smith wrote:
Is there an easy way to set [time] based on geographic location? Basically,
NY -5, SF -8 (or -7 for DST) -0 for London, etc.


You want to store UTC?

http://www.mvps.org/access/forms/frm0051.htm

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.