>>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
Yuri,
This is very interesting code! I might try this just to see if it will work for me but I think I've gotten to the heart of the problem. I am remoting into a box without the adequate DSN files for the ODBC connection(s); I may need to copy/install them. I have started another thread to address this.