As you indicated, packing the tables isn't an option because this requires exclusive access to the tables and this is a live production system. We are using Visual FoxPro for...

Ryan,

Unfortunately the ODBC settings don't work when using an SQL linked server. If you issue a simple command SELECT * FROM [LINKEDSERVER].[DATABASE]..

from a program or from Query Analyser it...

The problem I've had with the ODBC driver is that it seems to return deleted records from the FoxPro database & I haven't found a way of either supressing this...