There are 2 major differance

1. Snapshot type Recordset is avaliable at workstation

2. Snapshot is nonupdatable and ReadOnly.

MTS is Microsoft Transaction Server.

This property is avaliable with COM+ Technology.

Same as Begin Trans Cummit Trans Etc. but alot more features

ADO :ActiveX Data Object is Microsoft's new universa data-access frame work that encompasses the functionality of DAO(Data Access Objects) RDO(Remote Data Ojects) as well as almost any another data access method. ADO uses new database connection frame work called OLEDB which allows fast and more flexible access to multiple data providers and ADO wraps it all into one easy to use interface. Therefore it is possible to write database applications that can scale easily from single user database to complex client/server systems.