Hi,

TEXT TO lcsql1 noshow
	sp_addlinkedserver 'VFPTESTLINK1', 
			'VFP', 
		        'VFPOLEDB.1', 
			'E:\Office\SHC-Membership\SHC-Membership-Upgrade-Current-new\Data\MEMBERSHIP.DBC'
ENDTEXT

?SQLEXEC(nHandle, lcsql1)

I think is the table problem, because I also face the same problem to access VFP DBC using 3rd party software. Some tables are missing. However, I don't know what wrong is it...