Why MSMQ Series?
Provides one of the simplest solutions for communication between distributed system in diff environment and guarantee the delivery of messages even if the system shut downs. Adv of DAO Better performance , Compatibility with ODBC, ability to specify relationship between tables , provide access to validation rules , support DDL and DML Note: DAO works with 32 bit whereas ODBC works with both 32and 16 bits DAO does heterogeneous joints for you, whereas ODBC forces you to do it DAO snapshots are read only while ODBC is updatable. ADO If you are developing an application that access data from datasource ranging from mainframe to desktop or if you are building a web application designed to provide user the datasources then ADO is selected. DDX : used to initialize the controls entered by user DDV : used to validate the data entered by user RFX: used to exchange data between database table and recordset variables When to use DAO/ ODBC If you are planning to work with JET DB then use DAO else
