Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Canberra, Australian Capital Territory, Australia
    Thanked 0 Times in 0 Posts

    Access 97 (Access97/Windows XP)

    Hi All,

    I have a number of Access 97 databases. When I open them on machines which have XP as their operating system the date changes to US date. Eg I pick from in a select query I select for a start date 1/5/02 (which in Australia is the first of May 2002), I am shown data from 5th January 2002. I have checked regional settings and they show Australian date format dd/mm/yyyy etc why then is XP messing up my dates. There are about four or five different databases and innumerable forms affected so I am hoping that a change in Control Panel or something rather than individual date fields is where the answer lies. <img src=/S/aussie.gif border=0 alt=aussie width=21 height=22> <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: Access 97 (Access97/Windows XP)

    This question has also been cross posted here in the Access board. Please post your replies there.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts