>>Thanks for answering. How do you share a connection? When I created them, I didn't see a means of sharing connections.
>>
>>If I understand the connection string properly, it lookS like this:
>>nVal = SQLCONNECT( 'MS Access 97 Database','Admin','Access' )
>>
>>This is how the connection is defined:
>>CREATE CONNECTION Access DATASOURCE 'MS Access 97 Database' DATABASE c:\temp.mdb
>>
>>I leave the advanced settings as they are.
>look at the DBSETPROP command - you can set the share connection property for remote views
>
>Arnon

What gives better performance, data from multiple datasessions running through a shared connection or through exclusivly used connections?