Access 2003 migration

[Guest]

I will appreciate if someone can help me.
We migrate from Access 2000 to Access 2003.
Some expresions in querys dont work anymore, like "iif(a = b, "a", "b")".
We understand that there are a library involved on that, but we dont know
how to fix it.
What we should do?

Thanks, Jorge, Chile

 

[Arvin Meyer]

Check your references. From any code window, select Tools ... References and
either uncheck uneeded ones that are marked as MISSING or find the correct
path to them.

Occasionally, you'll need to re-register a dll or activeX control, but I
believe it's more likely due to a missing reference.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

See Allen Browne's 10/24/04 reply to "Set DAO Reference".

It may help with this issue.

Jackie )