Mid command in query (2000 SR1)

[gsearley]

Hi,

I have been using a query in Access 97 without any problems. I have moved up to Access 2000 and the following field in a query brings up an error "Undefined function 'Mid$' in expression:

Descr Second: Mid$([mg_descrn],[Second Word Descr]+1,5)

I have checked it against the original Access 97 version and there is no difference.

Can anyone please help me?

Regards,

[rory]

Hi,
It sounds like you have a references problem. If you open the VBEditor (Alt+f11) and select Tools-References, do any of the ones that are checked start with 'MISSING:'?
If so, try unchecking the offending reference (make a note of what it is first, just in case) and compile your database.
Hope that helps.

[gsearley]

Rory,

Thanks for that - I had a MISSING:Microsoft DAO 2.5/3.5 Compatability Library

I unticked the box and everything works fine now - what is the compatability library anyway?

Regards,

[rory]

It is, as far as I know, there to ensure that old code will continue to run in newer versions.