J
Jack Cannon
I have an application developed in Access 2002. It also works fine in Access
2003. However when I migrate to Access 2007 I run into a strange problem.
The MDB file works correctly but I get strange error messages when I run the
MDE file in Access 2007. The first of several error messages that appear
states:
Function is not available in expressions in query expression ...
The functions within the query are: IIf, Trim and Nz.
This is not the only error message. The other error messages have blank
spaces in them and are not logical enough to try to describe.
Creating the MDE file using Access 2007 has no effect on the problem.
The machine is running Windows XP SP3 and the Office Suite 2007 has SP2
installed.
Any ideas?
Jack Cannon
2003. However when I migrate to Access 2007 I run into a strange problem.
The MDB file works correctly but I get strange error messages when I run the
MDE file in Access 2007. The first of several error messages that appear
states:
Function is not available in expressions in query expression ...
The functions within the query are: IIf, Trim and Nz.
This is not the only error message. The other error messages have blank
spaces in them and are not logical enough to try to describe.
Creating the MDE file using Access 2007 has no effect on the problem.
The machine is running Windows XP SP3 and the Office Suite 2007 has SP2
installed.
Any ideas?
Jack Cannon