>Tore,
>
>>My suggestion is simple: Use SQL and cursors as much as possible. If you take some time and analyse your system, you will probably be able to use SQL so much that your tables will almost never stay open. I have done this myself for many years, and whenever I have a power failure or something, I can be almost sure that my data is safe.
>
>But using views or select sql cursors still opens the affected tables!
>
>Like when I do -
>
>SELECT <fieldlist> FROM <tables> INTO CURSOR <mycursor>
>
>
>or
>
>
>USE <myView> NODATA
>
>
>the affected tables open too.
>
>How do make it as you have stated that 'your tables will almost never stay open'
>
>Thanks for your help and clarification.
>
>Dennis