I am working on Access97 on a MS Network. I also noticed that ALL Queries using the Date() are NOT working either instead I get an error that the function is unavailable.
Someone suggested that I should goto a Code Module, select Tools, References and check all references for all the users of this database to see if any are missing. That has not seemed to work. I also check to make sure that in the Control Panel, Regional Settings, Time tab setting are also similar. Again no joy.
I do some programming in VB 6, so I am wondering if some of the libraries and dll from VB6 have overwritten the Access version, and that they are NOT 100% compatible. Is this possible?
This problems does not seem to effect the Now() function, in fact that is working fine.
[This message has been edited by BSchulte (edited 01-10-2000).]