Access 2007 link to Oracle table shows different date formats on different PCs

joelhoffman
joelhoffman used Ask the Experts™
on
On several computers, I can open an Oracle table from Access through ODBC and see the date format of one field as M/DD/YYYY. However, on one computer, the date format is MM/DD/YYYY. Therefore dates on this one computer show "06/12/2004" whereas on every other computer the dates show as "6/12/2004." There must be some setting in the Access 2007 software on this one PC that is making it see the Oracle dates different from everyone else. I can go in and change the format in Design mode on the other PCs to "mm/dd/yyyy" (which Access warns me I can't do - lol) and they will then see the table as this one PC does. However, this is only a workaround, and a weird one at that since it shouldn't be allowed. Any ideas?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
Commented:
I would suspect it has to do with the Machine or Profile settings for that machine. Try logging onto the machine with a different user account if possible, and see if the settings follow the machine or follow the user.

If you need to change the Date format for the machine (Windows 7)

http://www.sevenforums.com/tutorials/3529-date-format-change.html

If it's a different operating system, search for "change date format for xxx", where "xxx" is your operating system.

If the Dates look okay for a different user, then you might have a bad profile (if changing the Date format doesn't work). If so, you'll have to delete and recreate the user account (but be aware that you will lose the settings and such for that user).

Author

Commented:
I've been on vacation the past week. I'll post the results of the last suggestion shortly.

Author

Commented:
We ended up changing the date formats in Excel - which worked fine but didn't analyze why they needed to be changed in the first place. I believe LSMConsulting's suggestion would have worked as well but we haven't had the time to explore that option and I didn't want to leave this question open without a response for any longer. Thanks again!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial