I'm using Delphi 3 on Windows 95 clients running on an NT server. Let's say the app in question is g:\appdir\app.exe
Most of the users don't have write access to the 'appdir' directory. Therefore, when the app tries to execute SQL commands, it bombs out because it wants to write temporary files in 'appdir.' It seems to want to create files like '_QSQL012.dbf'
To fix this, I have specified 'C:\' as the "Start In" directory on the desktop shortcuts - this ensures that the app write temporary files to a place where the user has write access.
Invariably, this gets messed up or bypassed and the app falls over. Is there a way to avoid creating these temporary files or to change the "Start In" directory programmatically after the app has started running?