>>>>>>Hi all,
>>>>>>
>>>>>>I'm trying to set up a pipe between an Access 2002 database and a FoxPro 6 free table. I'm connecting but I'm getting a syntax error ...
>>< snip >

>>
>>***I saw the issue! Misplaced bracket. Confirms to me that 90% or more programming errors are punctuation. Thanks, Cetin
>>
>>Matthew
>
>You mean solved ? I spotted this one :
>

>lcConnection = "{Driver=Microsoft Access Driver (*.mdb)};Dbq=\\dbsvr1\uadata\classic01\ClassicDesignServices.mdb;";
>"SystemDB=\\dbsvr1\uadata\secure\UA65FS.mdw;uid=administrator;"
>

>Missing + (and PWD ?)
>

>lcConnection = "{Driver=Microsoft Access Driver (*.mdb)};Dbq=\\dbsvr1\uadata\classic01\ClassicDesignServices.mdb;" +;
>"SystemDB=\\dbsvr1\uadata\secure\UA65FS.mdw;uid=administrator;pwd=mypassword"
>

Cetin

No password on the Administrator account at this time. I'll create a background service user account that only has access to the bare miniumum of tables when this goes live.

I didn't put the '+' in because I didn't have the line of code broken and continued in my test program, I broke it for convenience in this forum, although I now realize it would have been a red herring for the folks helping me.

Thanks,
Matthew