Microsoft Access 2010 and SharePoint 2010
With Access 2010 you can move your table to SharePoint 2010 and have user forms show up in SharePoint as well. One thing to note is that forms need to be created as Access web forms. This makes it so, for one, SharePoint can use these forms and two, it relies on the new Access Data Macros to drive the behaviors. Below is a nice diagram I found depicted the connection between Access and SharePoint 2010.

Let's take a closer look at how this all works!
Open Access and go to your database you want to send to SharePoint. You will need to run the Web Compatibility checker to make sure everything can transfer over smoothly. If any table fails, you will be given a list of the errors or problems so that you may try to fix them. Assuming all pass, you can then publish your database to SharePoint 2010. While publishing, Access moves the forms, reports, macros, tables etc to SharePoint. This will allow any users that have Access 2010 on their machines to download a local copy of the database to edit them if needed.
All your tables should now be SharePoint 2010 Lists and create all the necessary links between Access and the Lists. This way if someone were to download the database to their machine, Access will get all the SharePoint list data to maintain a local cache. While a user has this database open, Access will periodically sync with SharePoint with any changes made on either end.
All your forms get converted to ASP.NET (.aspx) pages, including javascript for any supported page events. The layout for these pages is mainly driven by HTML tables. One thing to keep in mind is that your controls on the form need to be placed within the cells. This helps Access transform the form into an appropriate .aspx page.
If your organization is looking to move your Access database(s) to SharePoint, you can do so with the peace of mind knowing everything should go over smoothly. Luckily, for those that are not using Access 2010, you can link SharePoint with Access 2007 as well. The link between Access 2007 and SharePoint is slightly different, but most functionality should still work as intended.
IncWorx Consulting is a leading Microsoft Gold Partner focusing on SharePoint Consulting, SharePoint Support, and SharePoint Application Development.













nt 2007 & 2010 to keep proprietary information safe and secure. We specialize in extranet portal development for firms and carefully architect solutions to provide secure collaboration for business to business needs. We quickly identify document sharing and repository needs and develop dynamic and business optimized solutions. IncWorx Consulting has the industry's best SharePoint architects and developers in the nation. IncWorx Consulting understands the technology needs and trends of the future and is providing assistance to the investment management elite. 

