- I notice that every time the use command is issued, one connection
is open, it would be fine for a few table, but could be a big problem
for hundreds table need to be open and run over the network, accessed
by many workstations.
How to avoid this?

- When using the use command seems the index is not automatically open
along with the table, so when SET ORDER TO command is issued, it
triggered and error, how to fix this? so the use command will open the
table along with its indexes.



Best Regards,

Sobari Tanuwijaya

Without positive attitudes, the best techniques in the world won't have
much impact.