Hi,

I have a system running P.sql. where i have multiple folders containing a
filelist+data. Today i wanted to add a new folder and i tested my program
running on the new filelist+data and it worked fine.
After my test i wanted to remove the folder but that was not possible since
the some files where in use (even that i had terminated my program).
Then i started the Monitor on the database server and i saw that the user
Administrator had some of the files open. When i tested it was not as user
administrator (but i have administrator rights). Then i saw that the user
Administrator had almost all files open (from the different folders), in
total 259 file handles where a normal user of our system would have 20-50
file handes.

My question is, why does this happend (is it some kind of service optimizing
the tables) and how can i disconnect the administrator from the files with
out crashing everything?

Best regards

Jacob