The benefits are increased security, as data is now being saved in a SQL Server database, and easier access, because information is available via 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.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 and Access have this covered with the "Move to Share Point" option, found under the Access Share Point Lists tab.This is similar to the option to move to SQL Server using the Upsizing Wizard, which first appeared with Access 97.It is saved in the SQL Server content database, contains certain field attributes, and supports lookups.Some limitations to keep in mind when creating a Share Point list are: Microsoft recommends a limit of 2,000 items per view to obtain optimum performance; Share Point doesn't enforce referential integrity; OLE Objects are not exported into Share Point; and validation of data is limited.
Share Point features include document management, workspaces, and the ability to set up custom lists and to utilize built-in workflows and out-of-the-box Web parts that cover everything from advertising events, to building a contacts list or an issues list, to managing user-created forms.To create a Share Point list from an Access table, first select the External Data tab, then click on the enabled Share Point List button under the Export group.Now you must specify the Share Point site where this list will be active by filling out the Export - Share Point Site dialog shown in Figure 2, or by right-clicking on your table and choosing Export to a Share Point List.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.
Choose a list and, under the Actions tab, click on the "Open with Access" choice.