2007 Compatablility or Missing dll?

[SkipVought]

Hi,

My colleague just got Office 2007 pushed out.

He has an Access 2003 db that is giving him this message

Function is not available in expressions in query expression

I wrote my own expression, using the Date() function and it failed.

I removed the Date() function from the expression and it executed.

Our HELP desk is telling him that this is a compatability problem. But it seems to me, like a missing dll in the office install.

What say you?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PHV]

Check the references.
Does the DB compiles properly ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

I've got to contact the owner. The VB Project is locked.

But thanx for the advice.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

I did a bit more testing.

In my 2003 Access, I can use Date() in a query criteria sucessfully in both instances, as illustrated below, linking to an Oracle table.

However, when I open this Access 2003 db, on the same machine, I get an error on ...

Where A.LPST < Date()

but no error on...

Where A.LPST < Now()

where LPST is a date field in an Oracle linked table.




Skip,

_{Just traded in my old subtlety...
for a NUANCE!}