Hello,

It looks like there is a temporary file that is created during a call to AlterTable.  In
my case the file is created in the current working directory.

Many of my users run in a locked down environment and are not local admins.  When trying
to alter a table I am getting a permission denied error.  From using the LUA Buglight tool
I found an *.ibk and a dbisam.lck that were created in the current working directory
during the AlterTable call.

I can have my users change the working directory on their shortcut to work around the
problem.  Is there a better way to correct this in my code?  I know I could change the
working directory to my database directory before calling altertable.  I was hoping that
maybe I missed a property somewhere that defined where this file is created.  ibk appears
to be an index backup file?  I see a suppress backup flag on the call to altertable, but I
would rather keep the backups if possible.  I really can't tell if that is related to this
file though.

Thanks,

Mark

There seems to be something about posting a question to a public forum that causes me to
think of other things I should have tried before posting

Setting
 Database.Session.PrivateDir := TempDirectory;
has solved my problem.

Thanks,

Mark

Mark,

<< There seems to be something about posting a question to a public forum
that causes me to think of other things I should have tried before posting
>>

At any rate, you've got the correct solution.

--
Tim Young
Elevate Software
www.elevatesoft.com