Further more I recieved this info from a NG.

Even though Asynch. execution is off in your connection, your views are
executing asynchronously. The reason is that the default fetch size for a
view is 100. This means that if a view returns more than 100 records it will
allow VFP execution to continue while it fetches the rest of the records.
Make sure the FetchSize for all views sharing a connection is set to -1
(all). This will give you synchronous operation and keep two queries from
trying to use the connection at once.

However, I have asynch off and fetchsize=-1.

Also what could 'execution is off in your connection, your views are
executing asynchronously' mean????

Can someone Please clarify.

Also thanks everyone that's helped me in the past with some excellent concise answers.
Tusind Tak!