Thanks Greg,

I will try setting the connection in code and see if it helps. It must be a FoxPro thing, the same ODBC drivers work just fine in Access. It's awful when Access can do what FoxPro can't.

Don