No 'Mid' Function in Access XP?

[DeutchBose]

I have an AccessXP database, converted from 97, that uses the 'Mid' function in one of its queries.

Access XP doesn't recognize the 'Mid' function...is there a replacement, or some other way to do the same thing?

 

[Corticus]

Mid() should work, but I've had what you've described happen before, specifically with the replace() funtion.

Anyways, you can use this in Mid()'s place, the arguments are in bold.
Left(Right([string],Len([string])-[START]+1),[LENGTH])

 

[SydneyGeek]

This is one of Access's little bugs. Updating a db from 97 wrecks some of the references. Check out this link for details on how to fix the problem.

By the way, if you need to update another db, I'd suggest creating a new, blank database in XP and importing everything from the 97 database into it. That way, the references will be correct -- and any other issues will generate warnings at import time.

Denis