|Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread|
|Messages 1 to 4 of 4 total|
|Access violation while Optimising (DBISAM)|
|Wed, May 7 2008 2:52 AM||Permanent Link|
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
Is there any way to set temporary folder in OptimiseTable function?
|Wed, May 7 2008 6:35 AM||Permanent Link|
"Jose Eduardo Helminsky"
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.
|Wed, May 7 2008 7:54 AM||Permanent Link|
Depending on the version you're using you can set Engine.CreateTempTablesInDatabase := True;
Roy Lambert [Team Elevate]
|Tue, Jun 24 2008 7:18 AM||Permanent Link|
<<Depending on the version you're using you can set Engine.CreateTempTablesInDatabase := True;>>
We are using DBISAM version 3.24