Discussion Locked

Access - Problem with dates

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Can anyone please offer me any explanations or solutions to why Access does not always recognise dates correctly. My database has tables linked by a date field. Buttons on one form opens other forms filtered on the date field. Until recently this worked well on 4 out of 7 networked computers(the database resides on my computer which acts as the server). The remaining 3 computers don't seem to be able to filter the date correctly and just present blank pages. Also an onLoad event set to find a record showing today's date only works on the first 4 computers. Recently I re-formatted my hard drive and reinstalled my software. Now my I too get blank pages where once I was able to see the correct data. I'm am sure that it is a date problem but am not sure if it is an Access problem or a computer problem. All the computers date and regional settings in both Windows and DOS are the same. I've tried setting the date format in my tables to long and short date but nothing works. I'm at my wits end trying to find a solution. Any ideas would be gratefully received.

5 replies

by steved

Here are a couple more points to check for consistency among all the computers:

1) Access version. Install Office 2000 Service Pack 2 on all computers.

2) MDAC version. Should be 2.5 or, ideally, 2.6.

I hope this helps.

Steve Diamond

by binarysleeper

Aha, I see you are a UK user like me. Access is a complete b******d with dates, often switching to the US format. The machines that have the problem - are they Win2000 per chance? The user setting may be UK but the machine's Locale might still be set to US. Run winmsd.exe from the Run box. See what system summary says the Locale is. You can also check out the language version of Access under the application folder. This has caused me no end of grief when using dates, so I tend to qualify my dates like this: to you and I 12/04/2001 is the 12th of April 2001. This is an ambigous date and thereore might be interpreted by a machine with a US setting as the 4th of December. So instead use your dates like this: 12-Apr-2001. Works a treat. Any probs, just mail me.

Cheers,

Mark@rds.co.uk

This discussion is closed to new replies.