I have one customer who frequently gets this error (using ElevateDB in Client/Server mode):

"ElevateDB Error #600 File manager error (Cannot delete the file C:\Windows\TEMP\MVNN-HP9321300268628339MyApplication 5163.table (OS Error: Access is denied.))"

For some reason temp files can be created without any problem, they just can't be deleted.  This is happening on all of the customer's workstations.

No other customers are having this problem.  

Has anyone else come across this?

= Steve

On 3/28/2016 6:38 PM, Steve Gill wrote:
> "ElevateDB Error #600 File manager error (Cannot delete the file C:\Windows\TEMP\MVNN-HP9321300268628339MyApplication 5163.table (OS Error: Access is denied.))"

Steve,

In any modern windows OS this is no longer a user writable location. I
would suggest to change your app temp tables path to user temp location.


Raul

Hi Raul,

<< In any modern windows OS this is no longer a user writable location. I
would suggest to change your app temp tables path to user temp location. >>

Thanks. I'm not actually setting this location. It's the default location being used by ElevateDB.

It's interesting that no other customer has this problem (we're talking thousands) with Windows XP, Vista, 7, 8 or 10).

I've tested it with Windows 7, 8 and 10 here using user accounts with default Windows access rights (no administrator access) and can't reproduce the problem.

Anyway, I am adding a setting that allows the location to be changed.

= Steve

Steve

I got an error message very similar to this when the Temp directory a user had was in a (small) drive partition which became very full. Moving the Temp directory fixed the problem.

Steve,

<< Thanks. I'm not actually setting this location. It's the default location being used by ElevateDB. >>

Hmm, in that case the Windows temp directory isn't set properly by the user, or the user doesn't have the proper privileges for writing to that directory.

Normally, EDB will get back from the OS something like this:

C:\Users\Tim\AppData\Local\Temp\

You can see it when you drop a TEDBEngine component on a form - TempTablesPath property.

Tim Young
Elevate Software
www.elevatesoft.com

On 3/29/2016 6:51 AM, Steve Gill wrote:
> Thanks. I'm not actually setting this location. It's the default location being used by ElevateDB.

Interesting - as Tim also posted EDB does not set this location by
default so it must have been set somehow else. I wonder if there is
another app or something that has messed with windows default temp path
so the default TempTablesPath setting points to something not user writable.

Not sure if you have access to the PC in question but would be
interesting to check windows temp path.

You can call edb engine GetTempTablesPath function to get the default
path as reported by OS or check what TEMP and TMP variables are set to ?
(type "set" on command line).


> It's interesting that no other customer has this problem (we're talking thousands) with Windows XP, Vista, 7, 8 or 10).
> I've tested it with Windows 7, 8 and 10 here using user accounts with default Windows access rights (no administrator access) and can't reproduce the problem.

Any way to see what their settings are for the above settings ? I
suspect they're the expected "C:\Users\<username>\AppData\Local\Temp\"

Raul

Hi Tim,

<< Hmm, in that case the Windows temp directory isn't set properly by the user, or the user doesn't have the proper privileges for writing to that directory.

Normally, EDB will get back from the OS something like this:

C:\Users\Tim\AppData\Local\Temp\

You can see it when you drop a TEDBEngine component on a form - TempTablesPath property. >>

You're right (of course ).  I checked some other computers (not the customer mentioned) and they are pointing to the user's temp folder, so there is something strange about the way this customer has his computers set up.

= Steve