>here are the two error messages I got (sorry, but they're in french)
>
>Test #1
>

>exec sp_addlinkedserver @server = 'test',
>	@srvproduct = 'VFP',
>	@provider = 'VFPOLEDB.1',
>	@datasrc = 'C:\Temp',
>	@provstr = 'Mode=Share Deny None;Password="";Collating Sequence=MACHINE'
>
>select * from test...livre
>
>Serveur : Msg 7403, Niveau 16, État 1, Ligne 1
>Impossible de créer l'entrée de Registre pour le fournisseur OLE DB 'VFPOLEDB.1'.
>

Sorry but I don't understand french. Do you have VFP OLE DB provider installed on SQL Server PC?

>Test #2
>

>exec sp_addlinkedserver @server = 'test1',
>	@srvproduct = 'VFP-ODBC',
>	@provider = 'MSDASQL',
>	@provstr = 'DRIVER=Microsoft Visual FoxPro Driver;UID=;
>		Deleted=Yes; Null=Yes; Collate=Machine;BackgroundFetch=No;
>		Exclusive=No; SourceType=DBF;SourceDB=C:\Temp'
>
>select * from test1...livre
>
>Serveur : Msg 7314, Niveau 16, État 1, Ligne 1
>Le fournisseur OLE DB 'test1' ne contient pas la table 'livre'. 
> La table n'existe pas ou l'utilisateur en cours 
>ne possède pas d'autorisations sur cette table.
>

>
>in the test #2, the file livre.dbf is located in the C:\TEMP directory and there is no special athorisation to access it

For part reference dosn't work for free tables. You have to use OPENQUERY

SELECT * FROM openquery(test1, 'select * from livre')
ISERT INTO openquery(test1, 'select * from livre') (...) VALUES (...)

See BOL for details. Take also look at Re: Linked server with the database on VFP Thread #700708 Message #727555.