Access has had a feature to “Upsize to SQL Server” for quite some time, and the “Move to SharePoint” feature in 2007 is very similar. It creates SharePoint lists for all the data, moves the data to those lists, and replaces the local tables in the database with remote tables linked to the newly created lists.

read more | digg story

And then here’s information from Microsoft’s website on Access 2007…

Introduction to integrating data between Access and a SharePoint site

You can share and manage data in many ways by using Microsoft Office Access 2007 with Microsoft Windows SharePoint Services 3.0. You can benefit from the collaboration features of a SharePoint site while continuing to use the data entry and analysis features of Access. For example, you can track versions of data, subscribe to alerts so that you know when changes are made, and manage permissions for the data.

Ways to work with data

When you use Office Access 2007, you can share, manage, and update data from SharePoint sites in several different ways.

Move data to a SharePoint site  When you move a database from Access to a SharePoint site, you create lists on the SharePoint site that are linked as tables in your database. When a database is moved, Access creates a new front-end application that has all the old forms and reports and the new linked tables that were just exported. The Move to SharePoint Site Wizard helps you to move the data from all your tables at the same time.

After the SharePoint lists are created, people can work with the lists on the SharePoint site or in the linked tables in Access while they use the features of a SharePoint site to manage the data and stay updated with changes. As an administrator, you can manage permission to the data and versions of the data so that you can see who changed it or restore previous data.

Publish data to a SharePoint site  If you are collaborating with others, you can store a copy of a database in a library on a SharePoint server and continue to work in the database by using the forms and reports in Access. You can link lists as tables in the database, which is helpful if you want to track data on the SharePoint site, and then you can create forms, queries, and reports to work with the data. For example, you can create an Access application that provides queries and reports for SharePoint lists that track issues and manage employee information. When people work with these lists on a SharePoint site, they can open the Access queries and reports from the View menu for the SharePoint lists. For example, if you want to view and print an Access issues report for a monthly meeting, you can do it directly from the SharePoint list.

When you publish a database to a server for the first time, Access provides a list of Web servers that makes it easier to navigate to the location where you want to publish, such as a document library. After you publish the database, Access remembers the location so that you don’t need to locate the server again when you publish your changes. When you publish a database to a SharePoint site, the database becomes available to people with permission to work with the SharePoint site.

Open Access forms and reports from a SharePoint site  Users can open lists in rich Access views from a SharePoint site. Access forms, reports, and datasheets can appear alongside other views on a SharePoint site. When you choose an Access view, Access starts and opens the requested form, report, or datasheet. This makes it easy for you to run a rich Access report on a SharePoint site without having to first start Office Access 2007 or navigate to the right object.

Create databases from SharePoint lists  You can open a SharePoint list in Access. If a database doesn’t exist, you can create it in Access and then create a set of forms and reports based on your list.

Take SharePoint lists offline with Access  If you need to take some work home with you, you can take your SharePoint lists offline with one click by using Access. You can work on your data in Access and then synchronize your changes or reconnect with the SharePoint site at a later time.

Import or link to a SharePoint list  You can bring a SharePoint list into Access by importing or by linking. Importing a SharePoint list creates a copy of the list in an Access database. During the import operation, you can specify the lists that you want to copy, and, for each selected list, you can specify whether you want to import the entire list or only a specific view. Linking lets you connect to data in another program without importing that information, so that you can view and edit the latest data both in the original program and your Access database without creating and maintaining a copy of the data in Access.

Integrating and managing data

After you move your Access data to a SharePoint site, you can manage who views the data, track the versions, and recover any data that is accidentally deleted. Better data integration between Office Access 2007 and SharePoint sites enhances performance and application design.

Manage permissions on SharePoint sites  You can assign varying levels of permission to lists and Access databases on SharePoint sites. You can assign limited reading permissions or full editing permissions to groups, and you can selectively allow or deny access to certain users. If you need to limit access to just a few sensitive items in a database, you can set permissions on specific list items on a SharePoint site.

Track and manage versions on SharePoint sites  You can track versions of list items and view the version history on a SharePoint site. You can recover a previous version of an item if needed. If you need to know who changed a row or when it was changed, you can view the version history.

Retrieve data from the Recycle Bin  You can use the new Recycle Bin on SharePoint sites to easily view deleted records and recover information that was accidentally deleted.

Improved performance for tables linked to SharePoint lists  Optimizations were made to the internal processing of tables that are linked to SharePoint lists to enable a faster and smoother experience than with previous versions.

Enhanced mapping of Windows SharePoint Services data types  With new support for multivalued fields and attachments, Access now supports more of the data types found on SharePoint sites, making the design and building of shared applications much simpler.

Tracking your data and workflow

You can use Office Access 2007 with information from SharePoint sites to track your organization’s data, issues, and workflow.

Tracking  Access now has a tracking template that interacts directly with the Issue Tracking template on a SharePoint site. The schemas are the same, and the Access solution can be used as a front end — for example, with forms and queries — against data from a SharePoint site.

Tracking the history of Memo fields  Memo fields are useful for storing large amounts of information. You can set a property that tells Access to retain a history of all changes to a Memo field. You can then view a history of those changes. This feature also supports the versioning feature on SharePoint sites, so that you can also use Access to view the changes that were made to the SharePoint list.

Integration with workflow on SharePoint sites  You can now use Access to interact with and report on workflows so that you can better gauge the project’s status and evaluate your business processes. The workflow reports can span multiple lists as well as information from multiple workflows.

~~~~~~~~~~~~~~~~~~~

Andrea Kalli Virtual Trainer and Assistant, LLC

Your #1 resource for Outlook training and SharePoint training

www.virtualassist.net

Andrea Kalli
Certified Internet and Social Marketing VA

Your powerhouse virtual assistant support for:
Keyword and Competition Research, on-page SEO, and Link Building strategies
WishList – Wordpress Membership Sites and Retention Strategies, Wordpress Support

MATERIAL CONNECTION DISCLOSURE: You should assume that I, Andrea Kalli, have an affiliate relationship and/or another material connection to the providers of goods and services mentioned in this page and may be compensated when you purchase from a provider. You should always perform due diligence before buying goods or services from anyone via the Internet or offline.

Tags and Categories: "access 2007" with "sharepoint 2010", "access" "training template" keeping track of, "microsoft access 2007" sharepoint, "outlook form" to sharepoint, access 07 and sharepoint, access 2007 and sharepoint, access 2007 and sharepoint 2007 collaboration, access 2007 and windows sharepoint services, access 2007 database and reports to sharepoint, access 2007 forms on the internet, access 2007 free sharepoint, access 2007 history changes, access 2007 internet based forms, access 2007 list synchronization with sharepoint 2007 list, access 2007 memo field history limits, access 2007 publish query to sharepoint, access 2007 sharepoint blog database, access 2007 sharepoint internet, access 2007 sharepoint open local copy, access 2007 sharepoint schema, access 2007 templates for employee training, access 2007 what's new, access 2007 workflow, access 2007; publish form to internet, access employee training templates, access query sharepoint integration "version history", access report template connecting to sharepoint, access sharepoint item history, access sharepoint memo, advantages of using access 2007 sharepoint, andrea kalli, assign sharepoint read write permissions outlook 2007, can i connect to datasheet on sharepoint via ms access, can't view access forms in sharepoint, can´t see changes made in access 2007 in the network, cannot link access 2007 to sharepoint 2007, cannot publish access to sharepoint, changes in microsoft access 2007, create a rating start in sharepoint list 2007, create history list in access form, create ms access report from sharepoint list, creating forms in sharepoint from multiple access tables, creating issue tracking website using access 2007, creating issues tracking in access 2007, creating workflows in access 2007, data entry access 2007 from internet, design a promotions page on sharepoint 2007, develop a questionnaire in access 2007 to send via email, easy publish access database online sharepoint, free access 2007 templates for employee training, freeware workflow for access 2007, history tracking on access 2007, hot to publish acess 2007 forms to sharepoint 2010, hot use access 2007 with sharepoint, how do you publish access 2007 on your network, how much history does access 2007 memo field store, how to connect sharepoint access 2007 database, how to create linked tables of sharepoint lists in access 2007, how to establish a comment history in access, how to link access report to sharepoint site, how to link an access 2007 form to sharepoint?, how to make an access report in sharepoint, how to pubish access form on sharepoint site, how to publish a report to a sharepoint library, how to publish access 2007 reports as web pages, how to publish access 2007 reports to sharepoint, how to publish access 2007database online, how to publish access form to sharepoint 2010, how to publish only access database reports to sharepoint, how to put access form on sharepoint, how to put version history of list in datasheet in sharepoint, how to use access 2007 in sharepoint 2007, how to use memo history in access 2007, howto publish ms access report, import access 2007 to sharepoint 2010, integrating access2007 in a website, internet access form sharepoinrt, link access report to sharepoint, link tables in access 2007 sharepoint, make design changes to access 2007 on sharepoint, make local copy of sharepoint 2007, microsoft access 2007 employee training template, microsoft access 2007 sharepoint integration video, microsoft access 2007 sharepoint intergration, microsoft access 2007 what's new, microsoft access form comments history, microsoft access forms integrate sharepoint video, microsoft access marketing project, migrate access 2007 to sharepoint, migrate outlook custom form to sharepoint, migrate outlook form to sharepoint, move access database to sharepoint issues tracker, move access database to sharepoint permission, move microsoft access application to sharepoint 2010, moving access database to sharepoint, moving data from an ms access database to a sharepoint site, ms access 2007 what's new, ms access copy data history, ms access form ms sharepoint, ms access forms publish to sharepoint, ms access printing sharepoint multi-select, ms access reportsas sharepoint web pages, ms access sharepoint step by step, ms access why use sharepoint, ms access word cloud, open access 2007 reports in sharepoint, open access form from sharepoint, origin of microsoft access 2007, outlook, outlook form to a website, print reports faster in access 2007, print wss list using ms access 2007, publih acesss 2007 to sharepoint 2010, publish 2007, publish access 2007 database to internet, publish access 2007 form, publish access 2007 form to sharepoint, publish access 2007 in sharepoint, publish access 2007 to sharepoint, publish access 2007 to sharepoint 2010, publish access data internet, publish access database sharepoint multiple users, publish access database to sharepoint, publish access form sharepoint, publish access form to sharepoint, publish access form to web, publish access report to sharepoint, publish access reports online without sharepoint, publish database in 2007, publish from access to sharepoint list, publish ms access form to sharepoint, publish ms access forms 2007, publish ms access forms on sharepoint, publish ms access read write sharepoint, publish ms access to internet, publish the form design in microsoft access 2007 in sharepoint, publishing a form to the internet access 2007, publishing a sharepoint list on the internet, publishing access 2007 data on sharepoint, publishing access 2007 database forms reports to sharepoint 2007, publishing access 2007 forms online, publishing access 2007 forms reports to sharepoint 2007, publishing access 2007 forms reports to sharepoint 2007 but not database, publishing microsoft access forms on sharepoint, publsh shared access database files on sharepoint, query sharepoint version history via access, run access reports in sharepoint, run an access application on sharepoint, sharepoint, sharepoint, sharepoint 2007 connect to remote list, sharepoint 2007 example list from connection to remote database, sharepoint 2007 list ms access form, sharepoint 2007 permission to publish a page, sharepoint 2007 publishing document, sharepoint 2007 whats new, sharepoint 2007 workflow reports permissions, sharepoint 2010 restore version from history, sharepoint create an access report that can be viewed online, sharepoint database access examples, sharepoint front end for access database, sharepoint how to report output all history, sharepoint list version view deleted, sharepoint ms access 2007, sharepoint multivalue field delete query linked table, sharepoint publish vs move, sharepoint synchronization and ms access, sharepoint version history restore, sharepoint what's new list connect, solution for tracking "changes to access", tag cloud in microsoft access, template ms access 2007 online, track forms on sharepoint 2007, update list in sharepoint same name access 2007, update sharepoint list with microsoft access, use access form on sharepoint, use microsoft access to retrieve sharepoint 2010 list permissions, use microsoft access to track time by category, using access to report on sharepoint lists, using sharepoint to track data, view access 2007 form in sharepoint 2007, view access 2007 forms in sharepoint site, view list item history in microsoft access, virtualassist.net, what's new in ms access 2007, whats new in microsoft access 2007, when i try to publish an access 2007 database to sharepoint 2007 it tells me it cant find the server

Related content

• Need Affordable SharePoint Development? Check out BPFast, LLC
• Yahoo Go for Mobile service for access to contacts, calendar, tasks
• What is SharePoint?
• Want Some Free Photoshop Video Tutorials?
• Use Tasks to track Contact correspondence in Outlook