MID Function Missing in Access 2002

[Guest]

Hi,

I'm working in Access 2002 with a database created in Access 2003. In 2003
I used a MID function to parse a filed within a query. When I try and run
the query in 2002 I receive the following message:

Undefined function 'Mid' in expression. (Error 3085)

Is the MID function not available in 2002? I find that hard to believe. Or
is there an Add-on that I need to turn on within the database, or download
from the internet?

Your assistance is greatly appreaciated!!

Manuel

 

[Allen Browne]

Mid() is present in A2003, as you expected.

Make sure that you have set the Security level to Low so your code can run:
Tools | Macro | Security
More info:
http://office.microsoft.com/assista...3&CTT=8&Origin=EC011081751033&Product=acc2003

Then from the code window choose References on the Tools menu. See if any
are marked "MISSING". More info:
http://allenbrowne.com/ser-38.html