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 mb
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
by mb
by mb
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending