Built-In Functions not working

I have a DB that was built in Access 97. There are serveral queries that use
the Mid, Right, or Left function. After converting to 2002 I am now getting
the error "Undifined function "Mid" in expersion"

I tried rebuilding the queries and can see the Mid and other functions in
the list of Built-In functions.

Any help would be greatly apperciated.

Kevin

Kevin wrote:
I have a DB that was built in Access 97. There are serveral queries that use
the Mid, Right, or Left function. After converting to 2002 I am now getting
the error "Undifined function "Mid" in expersion"

I tried rebuilding the queries and can see the Mid and other functions in
the list of Built-In functions.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Common problem. Open a VBA module. On the menu bar select Tools
References. Make sure any Missing items are removed. Make sure you
have a VBA library checked, like "Visual Basic for Applications" or
"Microsoft Visual Basic for Applications Extensibility 5.3." Compile
and compact.
--
MGFoster:::mgf00 at earthlink decimal-point net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQl7Xy4echKqOuFEgEQIAKQCg86Ks2SMa4sFwpfOzkGQmbK eKUOoAoPC6
r0lQJW3jToXKSxsg7dqDpiTM
=6BaC
-----END PGP SIGNATURE-----