Mike,
one more idea (after a cup of coffee <g>):
You could create an Access MDB as some kind of a middle layer that contains one query for each table in the other MDB (you might have to "attach" those tables to your MDB). In the queries you could specify new column names with the "AS" clause, so the names are VFP compatible. Then you could base your VFP views on those queries.
Maybe renaming the columns is already possible in the attached tables, so you get around the additional queries. But I don't really remember, if that's possible.
BTW: Attaching tables and building the queries could be done automatically by writing some lines of Code in the MDB.
Armin