Built in Functions not working

[Snewb]

Hi, I have a database in Access 2000 format that runs just fine on my work PC which is running XP Pro and Access 2003. When I run it on my laptop (Vista Ultimate and Access 2002) I have a problem where it doesn't recognise the Mid function (or Left, right etc...for that matter). Everytime I try to run the query I get an error 3085 Undefined Function 'Mid' in Expression. Other databases work fine, it just seems to be this one. Can you please explain why this is happening and how I can get around it. Cheers

 

[pbaldy]

This is typically a reference problem:

http://www.mdbmakers.com/forums/showthread.php?t=2757

 

[Moniker]

Specifically, this is the Microsoft Access X.0 Reference Library. In your DB that won't work, open the code window (press F11), and go to Tools -> References. You'll most likely see something very similar to this (along with plenty of other stuff):

MISSING: Microsoft Access 12.0 Object Library

Uncheck it, and scroll down to the version of the object library suited for Access 2000 (10.0 or 11.0, depending on the service pack and other updates). Check it, close the references, and you're good to go.

 

[Snewb]

Thankyou

Hi, big thanks to you both for the speedy and helpful response. It was actually a missing reference to MS Word 11.0 which I had to change to 10
Cheers