I am in the middle of replacing several Access 2003 applications with Access 2010 versions. None of the users have MS Access installed so I package and deploy these applications along with Access 2010 runtime. I first remove all of the old 2003 applications and access 2003 runtime then install the new applications. The workstations are a mixture of Windows 7 and Windows XP.
On one of the Windows XP workstations I get the following message when trying to run some options in the new application:
Function is not available in expressions in Query expression 'Date('
The new application runs fine on other XP workstations. Any ideas on what the problem could be and how to fix it?