Hi Sergey,
Thanks for your help.
Would you know why I cannot access any FoxPro tables that contain a AutoInc field with a linked server?

I get the following message:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IColumnsInfo::GetColumnsInfo returned 0x80004005: The provider did not give any information about the error.].