>IBM Client Acess(32 bit) drivers.
>
>Flush the Bombers, get the subs on alert, were going to DEFCON 1


Here is one way to do what you want.

on pc setup a system DSN on the system using Cleint Access driver--(Mainsys)

In fox
as4sys='Mainsys'
username='NAME'
pWord='PWORD'

or use properties if you like

Store SQLCONNECT('&as4sys','&username','&pword') TO gnconnhandle

if gnconnhandle<1
    = AERROR(aErrorArray)  && Data from most recent error
    errflag=aErrorArray(2) && Most Ralivent error
else
    SQLQuery="SELECT * FROM yourdate where whatever=whatever"
    ck=sqlexec(gnconnhandle,SQLQuery,"mylocalcopy")

    If ck<0
        = AERROR(aErrorArray)  && Data from most recent error
        errflag=aErrorArray(2) && Most Ralivent error
    else
       do you thing here
       copy to access
    Endif
endif


if gnconnhandle>0
    sqldisconnect(gnconnhandle)
endif	

What version of driver are you using?

HTH
Jeff