By the way, check out Fastxtab in the UT downloads section. It's much faster than VFPXTAB. I wrote about it in the August 2003 FoxPro Advisor.

>I have a problem that is driving me crazy at the moment. With the following code, I have no errors when I run it in the foxpro environment, but when I compile it and run it from the executable I get to messagebox 1.5, then it gives the error 'File does not exist'. Anybody have any ideas/insights into what could be causing this problem? The code is running from a .prg called by a button on a form.
>
>SELECT authffs
>MESSAGEBOX("starting FFS crosstab 1")
>SELECT Authffs.saa, Authffs.mo, COUNT(Authffs.compliant);
> FROM authffs;
> GROUP BY Authffs.saa, Authffs.mo;
> ORDER BY Authffs.saa, Authffs.mo;
> INTO CURSOR SYS(2015)
>MESSAGEBOX("starting FFS crosstab 1.5")
>DO (_GENXTAB) WITH 'Query',.t.,.t.,.t.,,,,.t.,1,.t.
>MESSAGEBOX("starting FFS crosstab 1.6")
>SELECT query
>COPY TO ..\data\FFS6motot.dbf
>MESSAGEBOX("starting FFS crosstab 2")