Ms access update query not updating records
Microsoft Data Access Components (MDAC; also known as Windows DAC) is a framework of interrelated Microsoft technologies that allows programmers a uniform and comprehensive way of developing applications that can access almost any data store.Its components include: Active X Data Objects (ADO), OLE DB, and Open Database Connectivity (ODBC).There have been several deprecated components as well, such as the Microsoft Jet Database Engine, MSDASQL (the OLE DB provider for ODBC), and Remote Data Services (RDS).Some components have also become obsolete, such as the former Data Access Objects API and Remote Data Objects.
The current version is 2.8 service pack 1, but the product has had many different versions and many of its components have been deprecated and replaced by newer Microsoft technologies. The latest version of MDAC (2.8) consists of several interacting components, all of which are Windows specific except for ODBC (which is available on several platforms).
MDAC architecture may be viewed as three layers: a programming interface layer, consisting of ADO and ADO.
NET, a database access layer developed by database vendors such as Oracle and Microsoft (OLE DB, .
NET managed providers and ODBC drivers), and the database itself.
These component layers are all made available to applications through the MDAC API.
The Microsoft SQL Server Network Library, a proprietary access method specific to Microsoft SQL Server, is also included in the MDAC.