Subject Re: exe problem From Mervyn Bick <invalid@invalid.invalid> Date Mon, 5 Oct 2020 10:34:30 +0200 Newsgroups dbase.getting-started On 2020/10/04 19:01, Charlie wrote: > I’m running windows 10 on a new computer.  I installed 1130b2550 and 1130runtime-b2550.  My old computer ran these perfectly. > > Actually this program runs great in dbase.  However when I run the exe file that was built in project explorer I have run into a couple unexpected errors. > > I get this one when I run a particular report, other reports run fine… > > Database Engine Error:  Permission denied:  C:\windows\system32\_QSQL000.DBF > > The following script is where the error is pointing….. > >    database = form.form.database1 >        sql = "select i.*,c.*from golfers_scores i inner join dbname c on i.dbname = c.dbname order by i.lname,i.fname" >        requestLive = false >        active = true > > The other error is… > > Error:  Access denied:  tempworkfile.txt > > It seems to be some-sort of a permission problem having to do with a temp dbf file that is deleted at the end of the script. > > Appreciate any help or suggestions. > Whenever you use an ORDER BY clause in a select statement dBASE creates a temporary file named _QSQLnnn.DBF  This file is usually in the same folder as the program. I have no idea why your report is trying place the temporary file in C:\windows\system32 but Windows 10 regards this as a definite no-no. Do any of the other reports that do run include an ORDER BY  clause? Where do you place tempworkfile.txt? Mervyn.