Current recordset does not support updating
Large updates become much easier to perform when you understand some of the basic principles of database design.
An Access database is not a file in the same sense as a Microsoft Office Word 2007 document or a Microsoft Office Power Point 2007 slide deck.
For example, the Join Data example is built around an ADODataset component that uses the previous SQL join.
If you run it, you can edit one of the fields and save the changes (by moving off the record).
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).Later Microsoft released upgrades to MDAC as web-based redistributable packages.Eventually, later versions were integrated with Microsoft Windows and Internet Explorer, and in MDAC 2.8 SP1 they ceased offering MDAC as a redistributable package.For information about entering new data in a database, see the article Add one or more records to a database.Read this section if you are new to Access or unfamiliar with the concepts behind relational databases.