I have remote server which executs VFP SP into a table on a remote machine. Then from a client machine I get records from that table using SQLEXEC. After that the remote table becomes not accessable for remote server. If remote server tries to run SP again I have a message 'Access denied'. If I dont use SQLEXEC but simply SELECT * FROM 'remotetable' and then USE IN 'remotetable' everything is working fine. So I assume that SQLEXEC holds the remote table. My question is how to 'release' a remote table?
Thanks Mark