>Does anyone know a way so that after a SQL statment the tables involved are closed without further coding?
>
>My problem is that after a SELECT-SQL the tables remain opened and have problems with some other forms which use the same tables in my application.
Your SQL function should track which table need to be open and close after. You can easily setup this with IF USED('...