Recently a conversation came up at our shop pertaining to the use of
seem to believe that it no less efficient than OPENing a file. Others
believe it opens and closes the file each time....
If I use it, it's for sitautions like poping a code description on the
screen in a small program, or sometimes when maintaining a n already loose
program. Never from main routines. Things that concern me are... Does the
system whether it be UV/D3 whatever... Open this file and close it each and
every time, or when it opens it does it leave the file open until program
execution is halted. I honestly do not know the true answer... I have never
really looked into it deeply. It's notsomething I spread the use of, but do
use on occasion so it's never been a top priority to know the answer too...
I have written a few tests and in the long run they seem to come out
equivelent at run time.
I look at it this way if ACCESS can use it in an efficient way why would
basic doing anything else??? I would assume ACCESS leaves the translated
file open as well... (Uh oh another thing to think about)
This will probably start a whole coding ethics thread(which could be
interesting), or die(not interesting)...
I am interested in hearing the thoughts/facts on the use of it....