PARSENAME is a rEaLLy great tool here. Here's another way that isn't nearly as esthetically pleasing but is probably faster, just because it doesn't parse the string four times....
It's time to walk away from Jet 4.0. Setup your 64bit server to use Microsoft.ACE.OLEDB.12.0 too. Go to microsoft's download here grab and install the 64bit one: