Function errors in Microsoft Access 2003 (Date, Trim, Function)
Posted on 2011-02-27
I am in the process of migrating to Win 7 from XP. The main issue every time I change to a new OS is getting all my programs to work. The most important item to work 100% is my old Access database. It was originally written in Access 2.0 (Windows 3.11) and has been converted and modified as I changed Access versions over the years. In XP, I am presently using my database with Access 2003 without any glitches. After installing Access 2003 in Win 7 with all its SP's and updates, a few functions do not work. Both Date=() and Now=() are not recognized, as well as Function and Trim that I use in reports.