>>>Hello, Don
>>>
>>>I've runned once in this problem, and I solved installing MDAC 2.5. in the client computer. Please verify if this is your case.
>>>
>>>Hope this helps,
>>
>>I and all of my clients are running Windows 2000. I think MDAC is included in Win 2000.
>
>FWIW, the MDAC 2.5 is up to SP 2 which is installed with the W2K SP 2. You didn't say whether you've applied the latest SP, but if not, might be worth checking.
>
>Ref: http://www.microsoft.com/data/download.htm

Yes, we have the lastest SP.

I have narrowed down my problem.

I build my views on the fly into a temporary dbc on the user's local drive.

The fields, joins, select wheres and order by come out of my meta data file.

When the code creates the select SQL statement it is normally larger than 1056 charaters or what ever VFP allows so I text to file the SQL statement into a separate .prg file also on the user's local drive. The code is something like :

cPrgFile = "c:\temp\common\sql.prg"
do (cPrgFile)

It works on my computer and not on my users.

On the user's computers I get an error message "'sql.prg' not found"

I have checked for cPrgFile on my user's computers immediately before trying to run it and it is there ie file(cPrgFile) = .t.. It is there after I exit VFP.

I cannot believe this is a problem of directory rights since the same program creates the directory c:\temp\common as well as the database c:\temp\common\common.dbc.

Any thoughts would be most appreciated. This is a nightmare to troubleshoot since I have to do it with "wait windows" in the *.exe file to run it on a user's computer which is about 20 meters distant.