Hi,

We have written Windows service to optimise our DBISAM database. We use OptimizeTable('',TRUE) function to optimise. Because its runs as
service, it create all the temporary files under Windows, System32 folder. My virus scanner blocks these files so, some times I’m getting
access violation.

Is there any way to set temporary folder in OptimiseTable function?

Thank you,
Regards,
Sachith

Sachith

Just before you open any table or query just set

Session.PrivateDir := ExtractFilePath(ParamStr(0));

In this way you drive DBISAM to create temporary tables in the same folder
that your service is located, but you have to be sure that the app has all
rights to this folder.

Eduardo

Sachith


Depending on the version you're using you can set Engine.CreateTempTablesInDatabase := True;


Roy Lambert [Team Elevate]

Hi Roy


<<Depending on the version you're using you can set Engine.CreateTempTablesInDatabase := True;>>

We are using DBISAM version 3.24

Regards,
Sachith