Hi Tore.



I run into this manipulate an accdb thing problem and try to connect to it. I run a Win 8.1 machine with VFP tables.

I found this thread and tried it. But I get -1 as a return. AERROR shows 1526 / "Data source name not found and no default driver specified"

Do you have any ideas what I'm doing wrong?


Thanks

Lutz

>>i need to get data out of access from vfp9.2 under windoes 8.1
>>
>>does anyone have the connection string
>>
>>Thanks
>>
>>Peter
>
>

>lcSourcefile = 'D:\DATA\Yourtable.ACCDB'
>lnConnHandle = SQLSTRINGCONNECT("Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + lcSourceFile)
>