Error 3075: Function not available in expressions (Access 2002 - 2007)

Question

I have an application written in Access 2000 (MDB).

From this applicationAccess 2000 MDB,built in to an MDE file in Access 2002 format.

(I do it through an automated program that first generates a Access 2002 (temporary) used to create the MDE (Access 2002) final.)

This works fine and the MDE file (Access 2002) is running without problems in Office XP.

But when I try to run under Office Access 2007, the following error occurs:

Error 3075 :

Function not available in expressions in query expression '(Left (Nz (det_Facturas.tip, "a"),

1. = ".")'

This error occurs (using the MDE file in an Office 2007 environment) when the program tries to print a report in the Record Source (RecordSource), has the following SELECT:

SELECT Cus.name, Cus.dni, Veh.num, Veh.model, Inv.fecha, det_Inv.tip, (Left(Nz(det_Inv.tip,"a"), 1) = ".") AS ord, det_Inv.qua, det_Inv.price,
FROM (((Inv LEFT JOIN Cus ON Inv.idc = Cus.id) LEFT JOIN Deposits ON Inv.idd = Deposits.id) LEFT JOIN Veh ON Deposits.idv = Veh.id) LEFT JOIN det_Inv ON Inv.id = det_Inv.idf;

However, if I run the MDB (Access 2000) without compiling under Access 2007, no error occurs.

Neither the Service Pack 2 for Office 2007 (office2007sp2-kb953195-fullfile-es-es.exe) or the patch (office-kb944449-fullfile-x86-es-es.exe) Item:945429"Description of the Spanish version Patch Package Access 2007 (Access-is-EN.msp): February 15, 2008" solve the problem.

The operating system is, in all cases, Windows XP.

I need help, thanks

Answer 1

Just in case you are still waiting for an answer...  It sounds like a Reference problem.  I would check Tools - References in any Code window.

---

-- Gina Whipp 2010 Microsoft MVP (Access) Please post all replies to the forum where everyone can benefit.