Updating ms access database
The focus of this article is to show how and where MOSS integrates with Access and how an end user can configure these two products to build a solution.), and a Web-based interface (the browser).
However, another operation—linking lists in Share Point as tables in Access—turns out to be a much more effective way to integrate Access and Share Point.Creating a Share Point list from an Access table is a good place to begin.A Share Point list is very similar to a table in Access.In one spot you get configurable relational tables, simple queries (and complex ones), a drag-and-drop front-end form creator, reports based on the data, and the ability to configure multiple users.Building solutions based on Access and Share Point makes sense both for organizations looking to pool resources and talent, and for individuals who want to take advantage of applications and skills built up over the years.Share Point Services (WSS) Users Information List, is also imported and linked in by default.And an issues table is created called "Move to Share Point Site Issues." Here you can review any conflicts with the data.Share Point has an answer for each of these issues.While Access has its limits, it is powerful and friendly, especially for those who don't write code for a living.Choose a list and, under the Actions tab, click on the "Open with Access" choice.A dialog box pops up that asks for the name of the database (new or existing).