VisualFoxPro and Access or Visual Basic

[Waxime]

i have visualfox pro table and i want to connect to him. For read, not problem. But for write there is the problem

i read on microsoft web site only RDO connection can write in foxpro table
http://support.microsoft.com/defaul...&NoWebContent=1

i try that
add "Microsoft remote Data Object 2.0" in reference and that
-----------------------------------------
Private Sub Form_Load()
'
' Using a DSN-less connection to open a free table
'
cn.Connect = "SourceType=DBF;" _
& "SourceDB=C:\Vfp\Samples\Data;" _
& "Driver={Microsoft Visual FoxPro Driver}"

cn.CursorDriver = rdUseOdbc
cn.EstablishConnection "rdDriverNoPrompt"

SQL = "select * from customer" 'this should be a free table
Set rs = cn.OpenResultset(SQL, rdOpenKeyset, rdConcurRowVer)

rs.MoveFirst
Text1.Text = rs(0)
Text2.Text = rs(1)
End Sub
------------------------------------------

but that doesn't work i receive :
Run-time error '429':
ActiveX compoment can't create object

i try register again ... nothing (regsvr32 msrdo20.dll) and reboot after

i try VB6CLI.exe ..... nothing
http://support.microsoft.com/defaul...kb;EN-US;194751

Please help me !!!

[Waxime]

nobody know the anwser ???
i'm on windows 2k with visual basic 6.0 or access 97