Date() function in Access

I have used the 'Date()' function in Access on several occasions to insert
the current date into a field. However, I notice that on some computers, the
macro fails, saying it doesn't understand teh function. This is despite
using the same version of Access (2000) throughout the network, using the
same service pack (3) and checking that the msowcf.dll is installed in all
cases. I also checked regional settings to see if there was any clue there.
Any ideas?

Thanks in anticipation,

Dave

re: Date() function in Access

Has to be a references issue:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dave" <noneof@yourbusiness.com> wrote in message
news:uVmSb.19986$tQ6.1211755@wards.force9.net...[color=blue]
> I have used the 'Date()' function in Access on several occasions to insert
> the current date into a field. However, I notice that on some computers,[/color]
the[color=blue]
> macro fails, saying it doesn't understand teh function. This is despite
> using the same version of Access (2000) throughout the network, using the
> same service pack (3) and checking that the msowcf.dll is installed in all
> cases. I also checked regional settings to see if there was any clue[/color]
there.[color=blue]
> Any ideas?[/color]