>Hi,
>
>We were just going to start a new client/server project in VB/SQL. SQL database would be on a single Server only. We had planned to use MTS, basically for its 'Transaction Mgmt' abilities -- as we understood it, we could develop the COM objects as if it was a single user system, and MTS could be used to do 'Transaction Mgmt'.
>
>From your comments re MTS in another thread, it appears that we are on the wrong track. Can u please advise us ?
>
>Thanks

That is basically correct, although you should also use the context object to let MTS know when your objects are complete or when they failed. And, VB COM objects actually allow mutli-use where VFP's won't until the first service pack it seems.

BOb

I recomend the book DataBase Workshop, Transaction Server 2.0
SAMS Publishing by Roger Jennings...
You can find it at Amazon.