You are trying to do macro expansion in a literal string. In short, you cannot do this. If you want to do something dynamically, try this:

CREATE connection COE ;
connstring 'DSN=MS Access 97 Database;DBQ=' + gcDBLocat + ';DefaultDir='+ gcDefaDir + ';DriverId=25;FIL=MS Access;MaxBufferSize=512;PageTimeout=5;UID=admin'


HTH...

>Below is the connect string I use from within my code.
>
>CREATE connection COE ;
> connstring 'DSN=MS Access 97 Database;DBQ=&gcDBLocat;DefaultDir=&gcDefaDir;DriverId=25;FIL=MS Access;MaxBufferSize=512;PageTimeout=5;UID=admin'
>
>
>If this is not correct, what should I do to fix my problem?