Access 2007 link to Oracle table shows different date formats on different PCs
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!
ASKER