>To All:
>
>I have a VFP 9 app with remote views to a MS Access database; all is good for the standard Access tables. However, some of the tables in Access are of the linked type (passthru connection only). When I create a remote view for one of these and attempt to execute the SQL command within Fox, it gives me a connectivity error.
>
>Any ideas? Thanks,
Irv,
As an alternative you may try to create a temporary foxpro table, but I am uncertain whether Access is able to do it with any kind of linked tables.
oAccess = CreateObject("Access.Application")
= oAccess.OpenCurrentDatabase("c:\db1.mdb")
acExport=1
acTable=1
?oAccess.DoCmd.TransferDatabase(acExport, "dBase 5.0", "c:\",acTable,"Linked_table_name","Temp_VFP.dbf")
Good Luck