CurrentDB.OpenRecordset

[MPM1100]

Hi all,

I posted this earlier in Programming without response. So I thought I'd try
here.

I'm reverting back to Access 97 and running into a problem with the app and
the use of CurrentDB.OpenRecordset.

I am submitting a SQL statement for the domain which is where the problem
exists. In the SQL statment I am using the function Nz() which works fine
when viewing a queries in the query window. However, when I try to submit
the same SQL to OpenRecordset, I get an error telling me that the function
'Nz' is undefined.

It's been a while since I worked with A97, but I don't recall ever having
such problems. Is there a reference or otherwise I might be missing here?

Thanks in advance...
MPM

 

[MPM1100]

Figured this one out... It was a case sensitivity problem that 2000 and later
ignore. Hope this is helpful to anyone else...

Best!